how to convert xml to table

[shivanisrivarshini]

Laptops_Train.xml (673.2 KB)
I want to extract all the aspectTerms
How can I extract aspectTerms from this XML in table format

[qqilihq]

You can use the XPath node for that.

XPath — NodePit

[shivanisrivarshini]

ya i did for all other but
how can i have aspectTerms as title and have all set of aspectTerm in single cell

[qqilihq]

@shivanisrivarshini

how can i have aspectTerms as title and have all set of aspectTerm in single cell

You can extract multiple values to a single collection cell. There’s an option for that in the node configuration under “Multiple tag options”.

[shivanisrivarshini]

U mean
XPath data tag =string cell
Multiple tag options = collectiion cell

[shivanisrivarshini]

this is how im getting output if i keep
XPath data tag =string cell
Multiple tag options = collectiion cell

[shivanisrivarshini]

XPath data tag =node cell
Multiple tag options = collectiion cell

[shivanisrivarshini]

how can i get aspectTerms and all its attributes

[mlauber71]

Could you try converting it to JSON before extracting it? Could be worth a try.

Problems with parsing a XML-like file

I attach a workflow that extracts your values. I converted the XML file to JSON and then used the JSON path editor to define a path. The tricky thing is to find the path. That took some time. I exported the JSON file and used an editor (Atom on MacOS) to find the right row. Then you would have to click on an item you want and hopefully it would select and mark blue the values you want. I am not a JSON expert so I would have to click around until it fits. Then the workflow would ungroup the valu…