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
Solved! Go to Solution.
@nujjod Do you have a dummy available :-)? Then i can throw it into my designer to fix the problem :-).
Greetings,
Seb
Hi @nujjod
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)
Hi @nujjod
Here is how you can do it.
Workflow:
Make sure to set delimiter as none in the input tool.
Hope this helps : )
Happy to help : ) @nujjod
Happy new year to you and your close ones : ) May it be filled with happiness and prosperity =D
Works perfectly! thank you so much I appreciate your help