Split an input csv file into multiple output csv files

Highlighted
Five Stars

Split an input csv file into multiple output csv files

Hello,

I have about 700 input csv files and I want to make "n" output files using distinct value. 

My input files composed of 4 columns

"Product Name" , "Postal Code" , "Quantity" , "Date"

I want to make grouping by with Postal Code and as output i want n output files for each Postal Code

 

Any Help ? Smiley Sad 

this is what i have done so far.

Untitled.png


Accepted Solutions
Nine Stars

Re: Split an input csv file into multiple output csv files

Hi

Here is my suggestion

splite file with column.JPG

 

check the attached file

 

 

 

 

Regards
DGM
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Nine Stars

Re: Split an input csv file into multiple output csv files

Hi

Here is my suggestion

splite file with column.JPG

 

check the attached file

 

 

 

 

Regards
DGM
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Split an input csv file into multiple output csv files

Thanks alot for your help. thats what i really expected but whenever i tried to change tfixedflowinput by TfileInputList and Tfileinputdelimited i dont get the same result.

 

 

Can you help more please ? thanks alot 

 

Untitled.png

Nine Stars

Re: Split an input csv file into multiple output csv files

Sorry for the delai, was very busy

were you able to solve the issue?
Regards
DGM
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Split an input csv file into multiple output csv files

yess , Thanks alot for your help Smiley Happy 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now