Xpath creating incorrect data

Hi @ThomasRobsonPG

You can solve this by first seperating the customer as an individual section/xml. From here, you can query the fields to your desire.

image

For this, use Xpath node 1 to extract all the customers with the data type node cell. This creates a xml line for each customer.

Output

Next, add another Xpath node to query the customer specific fields. Something which you probably already have in similar form. Note: the null checkbox is not required.

This will now generate the correct output without the shift taking place:

image

See WF:
Xpath creating incorrect data.knwf (17.7 KB)

Hope this helps!

2 Likes