XML parse - comment or processing instruction expected at Line

Question

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.

1667289637_2dbd387a-92d6-4a53-a1dd-184d652f2d59 - Copy.xml

Felipe_Ribeir0 · Accepted Answer

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.