CSV split into 2 small CSV

[#1]

Hi Experts,

I have a File to File scenario where a CSV file needs to be split into 2 CSV's based on some keys and fields.

the input CSV file has around 80 to 90 fields. i need to make 2 different small CSV's. each with 10-15 fields.

what is the best way to work on this interface, please?

do i have to use multi mapping here?

what is the best way to read this CSV with 90 fields? do i need to use FCC to read the file?

do i have to create 2 separate mapping for 2 small CSV's or i can handle it in the one mapping itself?

please advice

[jagesh]

Hi Smith,

using File sender channel, you should be able to read csv with 90 fields. usage of FCC settings in file sender channel depends on the layout of your input file.

for the output, if you want to generate 2 separate files then you could have 2 options.

option1: use multi-mapping technique and through ID configuration you can process two separate messages through 2 independent file receiver channels. this approach is recommended one.

option 2: by using CCBPM/NWBPM depending on your PI/PO version.

Regards,

Jagesh