need help to achieve that We are source records with different dates and want to split into different files based on the month of those dates
I have input data from source table as below
Col1 Col2 Col3 -------------------------- abc newyork 2018-10-15 abc newjersey 2018-10-12 abc newyork 2018-11-15 abc newyork 2018-12-06
Output should have 3 files
one for Month 201810
abc newyork 2018-10-15 abc newjersey 2018-10-12
one for Month 201811
abc newyork 2018-11-15
one for Month 201812
abc newyork 2018-12-06
Solved! Go to Solution.
I afraid - this is will not work
filename defined before subjob start
need insert tFlowToIterate which could define and filename and store row into memory (hash or variables) and 2nd subjob - read data and append them to file
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema