Subject:Parent Child nodes creaed from conversion Author:Rick Scofield Date:29 Mar 2006 11:02 AM
Hello,
I would like to create a .conv (CSV to XML) that created parent/child nodes that I can later use more effectivly than a flat tree. My input file is sorted by product code then by color.My current conversion creates:
<root>
<row>
<PRODUCT>B25</PRODUCT>
<SIZE>28</SIZE>
<COLOR>MOS</COLOR>
<COLORNAME>MOSS</COLORNAME>
</row>
<row>
<PRODUCT>B25</PRODUCT>
<SIZE>29</SIZE>
<COLOR>MOS</COLOR>
<COLORNAME>MOSS</COLORNAME>
</row>
<row>
<PRODUCT>B25</PRODUCT>
<SIZE>30</SIZE>
<COLOR>MOS</COLOR>
<COLORNAME>MOSS</COLORNAME>
</row>
</root>
However I would rather have it look like:
<root>
<product>
<code>B25</code>
<color>MOSS</color>
<size>28</size>
<size>29></size>
<size>30</size>
<color>RED</color>
<size>29</size>
<code>B28</code>
...
</product>
</root>
Subject:Parent Child nodes creaed from conversion Author:Minollo I. Date:29 Mar 2006 11:16 AM
That sounds like you need a (double) grouping transformation. The easiest way is to probably post process the converted CSV file using XSLT and generate the format you need. You can find hints about how to do grouping in XSLT searching for "grouping" on this forum.