on 08-21-2014 6:22 PM
Hi,
I have an XML in JDBC format, which I would like to convert to Parent & sub-node format. Could someone help me with this conversion?
Input:
<MaterialInput>
<row>
<MaterialNo>ABC</MaterialNo>
<MaterialDesc>ABC Text</MaterialDesc>
<Characteristics>ABC-1</Characteristics>
</row>
<row>
<MaterialNo>ABC</MaterialNo>
<MaterialDesc>ABC Text</MaterialDesc>
<Characteristics>ABC-2</Characteristics>
</row>
<row>
<MaterialNo>ABC</MaterialNo>
<MaterialDesc>ABC Text</MaterialDesc>
<Characteristics>ABC-3</Characteristics>
</row>
<row>
<MaterialNo>XYZ</MaterialNo>
<MaterialDesc>XYZ Text</MaterialDesc>
<Characteristics>XYZ-1</Characteristics>
</row>
<row>
<MaterialNo>XYZ</MaterialNo>
<MaterialDesc>XYZ Text</MaterialDesc>
<Characteristics>XYZ-2</Characteristics>
</row>
</MaterialInput>
Desired Output:
<MaterialOutput>
<Material>
<MaterialNo>ABC</MaterialNo>
<MaterialDesc>ABC Text</MaterialDesc>
<Characteristics>
<text>ABC-1</text>
<text>ABC-2</text>
<text>ABC-3</text>
</Characteristics>
</Material>
<Material>
<MaterialNo>XYZ</MaterialNo>
<MaterialDesc>XYZ Text</MaterialDesc>
<Characteristics>
<text>XYZ-1</text>
<text>XYZ-2</text>
</Characteristics>
</Material>
</MaterialOutput>
Thanks
Alex
Use CollapseContext>Splitby value and map below fields
<MaterialNo>ABC</MaterialNo>
<MaterialDesc>ABC Text</MaterialDesc>
USeoneasMany for characteristics with Material
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think you need to adjust your target structure a bit.
<MaterialOutput>
<Material>
<MaterialNo>ABC</MaterialNo>
<MaterialDesc>ABC Text</MaterialDesc>
<Characteristics>
<text>ABC-1</text>
<text>ABC-2</text>
<text>ABC-3</text>
</Characteristics>
</Material>
to
<MaterialOutput>
<Material>
<MaterialNo>ABC</MaterialNo>
<MaterialDesc>ABC Text</MaterialDesc>
<Characteristics>
<text>ABC-1</text>
</Characteristics>
<Characteristics>
<text>ABC-2</text>
</Characteristics>
<Characteristics>
<text>ABC-3</text>
</Characteristics>
</Material>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.