I have a requirement wherein the name of the output file shud be dynamic as below (The data is extracted from DB table)
Also it contains header in format below
and footer in below format
Note: The file will also contain the data with 15 columns which will be placed after header and closed by footer.
Can you please suggest possible design to do so
Do you want to load all the tables into csv. files dynamically?
At the start of most of my jobs, I use a tSetGlobalVar component to setup some commonly used variables. One of them in the current timestamp, unsurprisingly named "timestamp", which I create with the expression:
You can use global variables created this way in most expressions and component settings. For an output file, you would set the file name to be "XXX_" + ((String)globalMap.get("timestamp")) + ".csv"
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
Practical steps to developing your data integration strategy.