Hello,
I am creating a workflow with the input tool and connecting to an xml file. I receive this error.
Error: Input Data (1): comment or processing instruction expected at Line:10 and Column:1
Looking at line 10 of the xml file, I see the body tag but not sure why it's failing on that line. Also attaching the file.
I am looking to analyze and extract inside both the header and body tags.
Grateful for any advice.
Solved! Go to Solution.
Hi @AshM
There is something strange with the structure of this XML. Even if you try to open it with the browser (with notepad ++ too), you get the bellow error message (same that you get with Alteryx):
Doing some research, i found that a common XML file must have just 1 root element: Multiple xml elements in the same xml file - Stack Overflow
If you look at your file, you have 2 root elements (Header - row 2 and Body - row 10, exactly the row that shows the error)
Knowing that, i separated the file into 2 different XML's (one for the header and one for the body) and parsed it, it worked. Please take a look at the attached workflow.
A great big thanks for assisting here and I see in the input tool where I had bought this in as .xml in your worflow you have imported as .csv. This gives me something to work on and some understanding as to whats going on with the file... Again, big thank you.
Ash