Skip to Content
0
Former Member
Oct 16, 2006 at 09:17 PM

File Adapter Content Conversion

17 Views

Hi all,

I got following sample flat file input, can we convert it to XML in file adapter' file content conversion?

Key1,Key2,Item1,Item2,Item3

0001,AAA1,001,Cup,100

0001,AAA1,002,Glass,100

0002,BBB1,001,TV,10000

0002,BBB1,002,Radio,100

<Orders>

<Order>

<Key1>0001</Key1>

<Key2>AAA1</Key2>

<Item>

<Item1>001</Item1>

<Item2>Cup</Item2>

<Item3>100</Item3>

</Item>

<Item>

<Item1>002</Item1>

<Item2>Glass</Item2>

<Item3>100</Item3>

</Item>

</Order>

<Order>

<Key1>0002</Key1>

<Key2>BBB1</Key2>

<Item>

<Item1>001</Item1>

<Item2>TV</Item2>

<Item3>100000</Item3>

</Item>

<Item>

<Item1>002</Item1>

<Item2>Radio</Item2>

<Item3>100</Item3>

</Item>

</Order>

</Orders>

Best regards,

chi