Required to secure the data from different nodes and link them based on barcode,line item

[ShruthiVijayaKumar]

How to access the below node in XML as the det nItem="1" denotes the line item and the outer xml has barcode ,based on combination of both we have to take each child node ...like wise there might be line item more than 1 so every time it should be the combo of barcode and litem.

[OTrieger]

@ShruthiVijayaKumar 

I would pulling it in as a CSV file and then filter the data based on these 2 items.

XML is basically a text file.

When getting it as csv file you might get the schema or might have all the text in 1 or 2 cells, you can split the text to rows using the Text to Columns tool.

[ShruthiVijayaKumar]

I think we cannot access as CSV from XML,getting below output... no data

[OTrieger]

@ShruthiVijayaKumar 

Ok, there are a few things that you will need to set in the Data Input tool

5. remove , and replace it with \0 for delimiter 

6. untick the box you will need the first row

7. add 6 zeros to the value

[binuacs]

@ShruthiVijayaKumar what is the expected output result?

[ShruthiVijayaKumar]

We have to take the value inside the sub noded each with the combo of  barcode(CHNFE) and nitem for each node,shared in the first image