Problémy s čtením dat XML v Data Interop Workbench

Question

Mám potíže s načítáním XML souborů a výběrem dat, která potřebuji, bez toho, aby se v Data Interop Workbench zobrazovalo více řádků s prázdnými poli. Zde je příklad:<\/P> Vzhledem k následujícímu XML souboru:<\/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.