Read XML data with multiple child nodes and transform into examples
etmpoon999
MemberPosts:2
Contributor I
inHelp
I have records in XML like the one below. Each record has one parent and are unique.
<标识> 14901 < / Id >
<目标>
<目标>
> < /细节
I am managed to use Generate Extract to read the XML data by manually adding 20 child XPathes. The resulting example is one row with a parent and 20 children like the one below.
I actually need examples of parents with each of its own child like the below.
I can't find how to transform the row into multiple rows by attributes. Please help.
And, may be you have better idea to extract the child nodes instead of manually adding child XPathes.
Tagged:
0
