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

Question

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.

41250221480635000103550010000016011376499294-procNFe.xml

Line Item_1.JPG

Line Item.JPG

ShruthiVijayaKumar · Answer

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

binu_acs · Answer

@ShruthiVijayaKumar what is the expected output result?

OTrieger · Answer

@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