Parsing XML tax return to be more reader friendly

Question

New User,

I am attempting to create a workflow to make reading the XML files that are used to file income tax returns out of Thompson Reuters OneSource Income Tax easier. I have a small sample of the sort of data I am working with. I can't seem to make any other solutions work. Any help would be great.

Note: This is saved as a excel file so that I could remove sensitive data. It comes out of the system as an XML file though.

Thanks again

XML example.xlsx

clmc9601 · Answer

Hi @Eboyd0379,

Have you tried using the XML Parse tool? If that doesn't help, could you attach screenshots of your current workflow and a more thorough XML sample? Instead of removing the entire line with the sensitive data, could you just replace the sensitive data with meaningless characters while keeping the <somewords>? This will help the community create a more robust solution.