Forum Discussion
Error importing XML
Hello PaulDBrown
have you been able to solve the problem with the replies given?
If so, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
All the best
Jimmy
Thanks for looking into this. Here is the rogue file:
Hello PaulDBrown
i was able to open the xml file. This xml-file however doesn't represent a table, but Excel-file. Try to open the xml-file with excel instead to check-out the data. However, also with the xml-function you should get somehow the data
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Thanks Jimmy for looking into this. How did you get PQ to read the XML file? (I tried using the XML as source first, then tried the Excel option; neither worked)
I finally resorted to saving each XML file as an Excel file (the files were of no considerable size or row count, so it was ok) and doing the transformations etc. on those. Bit of a pain, but anyway.
Thanks again.
Hello PaulDBrown
i just saved a copy of the file you send me on my computer and accessed it without any special settings.
This is the code that was created
Quelle = Xml.Tables(File.Contents("C:\Users\xxxx\Downloads\rogue.xml"))
Jimmy
Hello PaulDBrown
have you been able to solve the problem with the replies given?
If so, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
All the best
JimmyNo idea why, but just had another go at importing the xml file trhough PQ and this time it worked without a hitch.
Thanks again for helping out!