Hi Experts ,
I have a requirement where I need to split XML data into multiple CSV file and send to SFTP locations based on column value in the XML tag.
Below is an example of what I am looking for . Please note that the file needs to be split based on the first column value .Can you suggest how to do the same as I am new to PI . Please note that the column values will be dynamic.
Input XML file ( ignoring tags )
- 111222,PO123,C100000,Test Store,1/1/15,AB1000,Test Soft Toy
- 111222,PO123,C100000,Test Store,1/1/15,AB1001,Test Soft Toy1
- 111222,PO123,C100000,Test Store,1/1/15,AB1002,Test Soft Toy2
- 222111,PO321,C111000,My Store,1/10/15,AB1000,Test Soft Toy
- 222111,PO321,C111000,My Store,1/10/15,AB1001,Test Soft Toy1
- 222111,PO321,C111000,My Store,1/10/15,AB1002,Test Soft Toy2
The expected output should be
CSV1:
- 111222,PO123,C100000,Test Store,1/1/15,AB1000,Test Soft Toy
- 111222,PO123,C100000,Test Store,1/1/15,AB1001,Test Soft Toy1
- 111222,PO123,C100000,Test Store,1/1/15,AB1002,Test Soft Toy2
CSV2:
- 222111,PO321,C111000,My Store,1/10/15,AB1000,Test Soft Toy
- 222111,PO321,C111000,My Store,1/10/15,AB1001,Test Soft Toy1
- 222111,PO321,C111000,My Store,1/10/15,AB1002,Test Soft Toy2