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"