XML Reader Gegevensproblemen in Data Interop Workbench

Question

Ik heb moeite met het inlezen van XML-bestanden en het selectief ophalen van de gegevens die ik wil, zonder meerdere regels output met lege velden in de Data Interop Workbench. Hier is een voorbeeld:<\/P> Gegeven het volgende XML-bestand:<\/P> <<\/SPAN>document<\/SPAN>><\/SPAN><\/DIV> <\/SPAN><<\/SPAN>pages<\/SPAN>><\/SPAN><\/DIV> <\/SPAN><<\/SPAN>page<\/SPAN> title<\/SPAN>=<\/SPAN>"one"<\/SPAN> id<\/SPAN>=<\/SPAN>"001"<\/SPAN>><\/SPAN><\/DIV> <\/SPAN><<\/SPAN>objects<\/SPAN>><\/SPAN><\/DIV> <\/SPAN><<\/SPAN>object<\/SPAN> name<\/SPAN>=<\/SPAN>"thing1"<\/SPAN>><\/SPAN><\/DIV> <\/SPAN><<\/SPAN>property<\/SPAN> type<\/SPAN>=<\/SPAN>"string"<\/SPAN>><\/SPAN>Thing 1<\/SPAN><\/<\/span>property><\/div>

RenatoSalvaleon3 · Answer

From what I read in your sample, <pages> is an array of page that has a title and a single property.

Your feature path must be set like below. Checking the Property checkbox is probably not needed.  Your list exploder will do the rest of the pivoting.

The above results to the following;

If you are reading the XML from a path, you would not be able to see any option in the Select element to match dialog, so you have to type below in the Elements to Match text box:

document/pages

Hopefully, this helps, as your sample is very simple and XMLs can be quite complex until you get to know its pattern. Let me know if you have additional questions.