Hi,
I am trying to debatch a single csv file into multiple csv files, based on no. of records.
My format of csv file is :
10001, Name of product, 723.56, 2
10013, Name of product, 234.99, 1
10021, Name of product, 836.99, 9
10045, Name of product, 500.27.3
Have completed the following steps :
- Created flat file schema
- Created send and receive pipeline.
- Set the child delimiter of root node as 0x0D 0x0A
- delimiter type : Hexadecimal , Order :Postfix
- Set the child delimiter of child record node as ,(comma)
- delimiter type : Character , Order :Infix
Now when i drop the csv file in input location it gets picked up, but at the send location instead of 4 csv file, i get the same file which was dropped as input.
Kindly help.
Thanks ,
Piyush