Unable to process xml file with a specific format in alteryx

Question

Hi Team, I am unable to process the xml file with specific format as its throwing me error in structure but when i tried to process the sample xml solution is working in Alteryx. 15 00002041 6352 Prestacao de servico de transporte a estabelecimento industr 57 149 xxxx xxxx 1 1 3 1 0 0 04.00 1501501 Benevides PA 01 0 xxxxxxx Paragominas PA xxxxx Curitiba PR 1 1 3 Please let me any answers ASAP ,Thank you in advance for Regards, Shruthi.V

OTrieger · Answer

@ShruthiVijayaKumar

Instead of inputting it as XML, you can importing it as csv file, do what ever you want  and then save it back as xml with new data

ShruthiVijayaKumar · Answer

Can you please share me the snapshot of the data so that i can see how the child values are coming it and please help me out to get the same output

ShruthiVijayaKumar · Answer

unable to process the xml file with specific format: which tool(s) are you using? please post a sample workflow-I am using input tool and later xml parse tool, but in the input tool I am selecting type as xml and try to run it its throwing me error in structure: what is the error-Means i require all the sub directories or child nodes values when i tried to process the sample xml solution is working: what is "sample xml"? please post a sample workflow. John Doe 30 john.doe@example.com Jane Smith 25 jane.smith@example.com The Adventure Begins Robert Johnson 2022 Regards, Shruthi.V XML_Output.JPG