generate output file (csv)

[vidya821]

Hi All,

I have a requirement wherein the name of the output file shud be dynamic as below (The data is extracted from DB table)

XXX_YYYYMMDDHHNNSS.csv

Also it contains header in format below

#DATA;XXXXXX ;<YYYYMMDD<HHNNSS>>

 and footer in below format

#END;No_of_reecords

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

Thanks

[cterenzi]

Is the timestamp based on the system time or from another source?

[Anonymous]

Hello,

Do you want to load all the tables into csv. files dynamically?

Best regards

Sabrina

[vidya821]

Its based on system time

[vidya821]

There is only one table of 15 columns whose data has to be extracted in csv file
Data from all columns needs to be extracted

[cterenzi]

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:
TalendDate.getDate("yyyyMMddHHmmss")

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"

[Anonymous]

That's what I would suggest too.