XML to XLS

Hi all,

I’m trying to understang for the first time " XML" and the way of i need to extract data that i need in them.

I need to extract every row even when there not one tag.

for exemple here it’s missing the tag Accounted_CR

Do you have any idea ?

Thanks a lot for your help

1 Like

Hello @Leophil,
So If you want to extract everything from within that JELINE ROW tag, I would suggest this:

image

so you would have something like this in your XPath query:
.../JELINE_ROW/*

then set under Multiple Tag options to:
image

It should capture all the tags within that JELINE_ROW tag, it should also cut down on a lot of the code you have there.

Hope this helps,
TL

2 Likes