How to Extract XML Data into Table Format? (please see details)

[Ryanz3653]

Hi community,

I have a dataset where each row contains a unique ID and a corresponding XML code in another column. The XML code contains a long list of information. You can see an example of the XML code in the screenshot below. (on the left of screenshot)

To the right of the screenshot, you can see the extracted information in a table format, with each ID's information parsed and displayed in separate columns.

How can I efficiently extract the information from the XML code and convert it into the table format shown on the right?

I hope it's clear, please provide solution in workflow, thank you for your help! 

[Qiu · Accepted solution]

@Ryanz3653 
Try to use the XML Parse tool as below.