topic Re: generate output file (csv) in Talend Studio

generate output file (csv)

vidya821 — Fri, 14 Jul 2017 13:07:19 GMT

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

Re: generate output file (csv)

cterenzi — Fri, 14 Jul 2017 15:37:35 GMT

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

Re: generate output file (csv)

Anonymous — Mon, 17 Jul 2017 03:37:11 GMT

Hello,

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

Best regards

Sabrina

Re: generate output file (csv)

vidya821 — Mon, 17 Jul 2017 08:37:58 GMT

Its based on system time

Re: generate output file (csv)

vidya821 — Mon, 17 Jul 2017 08:39:47 GMT

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

Re: generate output file (csv)

cterenzi — Mon, 17 Jul 2017 17:33:20 GMT

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"

Re: generate output file (csv)

Anonymous — Tue, 18 Jul 2017 14:26:18 GMT

That's what I would suggest too.