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!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach