Parsing XML: invalid document structure

Hello!

I have a txt file and trying to convert it to XML but I'm having some issue

This is the table I have containing the xml structure:

and this is the error I got:

XML Parse (29) invalid document structure at Line:1 and Column:40 at row # 1

when I check the "Ignore xml errors" option I get this:

I tried "Root", "auto detect child", and "specific child name" to be Patients but all the same issue

I'm not sure how to fix this, I want each record to be in a row but it doesn't look like it's parsing anything

Thank you

Datasets

Output

Parse

Accepted answers

Here is how you can do it.

Workflow:

Make sure to set delimiter as none in the input tool.

Hope this helps : )

XML parsing v2.yxmd

All comments

@nujjod Do you have a dummy available :-)? Then i can throw it into my designer to fix the problem :-).

Greetings,

Seb

You will get this error when your XML is not complete/proper structure. As @Sebastiaandb said if you provide us with some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

Thank you so much @Sebastiaandb and @atcodedog05

I've attached the workflow and the txt file (I wasn't able to upload the txt file correctly because the content is XML, so I added a "t" in the beginning and it should be removed)

XML parsing.yxmd

Quick Links

Tags

Workflow
Output
Preparation
Datasets
Input
Developer
Help
Tips and Tricks
Common Use Cases
Server
Transformation
Developer Tools
Macros
Data Investigation
Best Practices

This months top contributors

AkimasaKajitani 389

Hollingsworth 335