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
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.