Forum Discussion

HaraldHBub's avatar
HaraldHBub
Frequent Visitor
8 years ago

Importing XML gives all data in single column

Hi,   I'm attempting to import data from an XML file we get exported from one of our systems. I have little experience with XML, so the error might be obvious. Excel opens it just fine and returns ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HaraldHBub,

Could you please upload the xml file to OneDrive and post shared link of the file here? The above XML file you post contains emoji.

Regards,
Lydia

  • HaraldHBub's avatar
    HaraldHBub
    Frequent Visitor
    8 years ago

    One Drive link to XML

     

    There you go. This is a dummy XML as the other contains sensitive information. This is exported from the same system and should contain the same structure, just a much smaller dataset.

     

    When I try to import and expand all my data comes in the Row query, Cell.Data.Element:Text column

     

    Thank you!

     

    Regards

    Harald

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HaraldHBub,

      I am unable to access the XML file, please share it in OneDrive and post shared link of it so that I can download the file from my side.

      Regards,
      Lydia