I have a source table/file with thousands of records, each record belongs one specific department, and number of department may grow.
and the requirement is to generate one file for each department and load corresponding data into that file, like that need to create files at run time depends on the number of department coming from the source.
as of now there are 4 different department from source file, so need to create 4 files at run time
FileName: file_10.txt File_20.txt
like that need to create, and what are the components are required to implements this
Solved! Go to Solution.
tFileInputDelimited --> tFlowToIterate
tIterateToFlow --> tFileOutputDelimited
Use the following expression for the output filename :
"file_" + (Integer)globalMap.get("deptid") + ".txt"
Talend named a Leader.
Kickstart your first data integration and ETL projects.
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