Skip to Content
0
Former Member
Aug 10, 2016 at 08:03 AM

Split XML file based on dynamic Column Values

122 Views

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