Forum Discussion

Babak133's avatar
Babak133
Copper Contributor
Aug 28, 2023

Cannot export XML data in Excel

I am getting an error when I try to export XML data in Excel.   When I do a check I see the following error: map is not exportable denormalized data   Can someone please advice?  
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Aug 28, 2023

Babak133 Excel can only export XML having a single level of nodes.

So this exports:

<main>
    <Sub1>data1</Sub1>
    <Sub2>data2</Sub2>
    <Sub3>data3</Sub3>
</main>

But this doesn't:

<main>
    <Sub1>data1</Sub1>
        <Sub1Sub1>data1.1</SubSub1>
    <Sub2>data2</Sub2>
    <Sub3>data3</Sub3>
</main>

Resources