how to convert xml to table

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

You can use the XPath node for that.

ya i did for all other but
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”.

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


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


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

how can i get aspectTerms and all its attributes

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

1 Like