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

1 Reply

  • 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