Data Interop WorkbenchにおけるXMLリーダーデータの問題

ChuckColeman

XMLファイルを読み込み、Data Interop Workbenchで空白フィールドが複数行出力されることなく、必要なデータだけを選択するのに苦労しています。例を示します:<\/P>

以下のXMLファイルがあるとします:<\/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><\/<span>}<\/<div>}}}}}}}}}}}}}}}}}}}}}}} I want to gather the page title, object name, and property text.<\/<span>

It should output 2 records like the following:<\/<span>

RenatoSalvaleon3

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.