Hi,
Request your suggestions on best way to convert CSV to XML
CSV u2013 MII should read below data from a file
1,a1,aaaa
1,a1,bbbb
1,a2,cccc
1,a2,dddd
2,a3,eeee
2,a3,ffff
2,a4,gggg
2,a4,hhhh
Intermediate MII XML
<Rowsets>
<Rowset>
<Row>
<Item>1</Item>
</Row>
<Row>
<Item>a1</Item>
</Row>
<Row>
<Item>aaaa</Item>
</Row>
</Rowset>
<Rowset>
<Row>
<Item>1</Item>
</Row>
<Row>
<Item>a1</Item>
</Row>
<Row>
<Item>bbbb</Item>
</Row>
</Rowset>
::::
::::
::::
<Rowset>
<Row>
<Item>2</Item>
</Row>
<Row>
<Item>a4</Item>
</Row>
<Row>
<Item>hhhh</Item>
</Row>
</Rowset>
</Rowsets>
Target XML
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<mainnode>
<repeatnode1>
<node1_id>1</node1_id>
<repeatnode2>
<node2_id>a1</node2_id>
<repeatnode3>
<name>aaaa</name>
</repeatnode3>
<repeatnode3>
<name>bbbb</name>
</repeatnode3>
</repeatnode2>
<repeatnode2>
<node2_id>a2</node2_id>
<repeatnode3>
<name>cccc</name>
</repeatnode3>
<repeatnode3>
<name>dddd</name>
</repeatnode3>
</repeatnode2>
</repeatnode1>
<repeatnode1>
<node1_id>2</node1_id>
<repeatnode2>
<node2_id>a3</node2_id>
<repeatnode3>
<name>eeee</name>
</repeatnode3>
<repeatnode3>
<name>ffff</name>
</repeatnode3>
</repeatnode2>
<repeatnode2>
<node2_id>a4</node2_id>
<repeatnode3>
<name>gggg</name>
</repeatnode3>
<repeatnode3>
<name>hhhh</name>
</repeatnode3>
</repeatnode2>
</repeatnode1>
</mainnode>
Mapping Points/Constraints
u2022 Repeatnode1,repeatnode2 and repeatnode3 in the output XMl are UNBOUNDED
Actions taken so far:
u2022 Read file using GetFile list Action block
u2022 Assign file content to Text_Loader.StringContentu2013 Using TextLoader action block u2013 Query u2013 Records in this text file may be up to 20000 , will all the records fit to Text_Loader.StringContent?
u2022 Read individual line u2013 Flat_file_Parser action block
u2022 Convert Line string to MII XML using String_List_toXML parser
u2022 Now problem is converting MII XML to XML
Optimal way conversion methodologies are requested.
Thanks
Rajesh