topic Re: OutPut file dynamic name in Talend Studio

OutPut file dynamic name

Anonymous — Tue, 22 Mar 2016 18:47:05 GMT

Hi guys, I am generating several files with tmap and outputfile and I want them to have the name from one row of t_map. This is my job:

This is what I am trying to do. With "talendgetdate" I can get the date but I don't know how to take the name of the row. I tried using global variables but with my job, the "setglobalvar" creates the global variable when I have already sent the file. I would like to know how can I do to make it first or another way to get the name of the row at tmap and put it into the name file.

Re: OutPut file dynamic name

Anonymous — Wed, 23 Mar 2016 08:08:29 GMT

Hi,

To get a tMpap property, use the row after the tMap : global. Click on this row to see all properties.

On your tFileOutputDelimited, use your property as global.your_property_filename. You can delete the tSetGlobalVar component because your data is in your global row.

Personally, rename your global row to avoid mistakes : an output row after a tMap don't use global variable.

Arnaud

Re: OutPut file dynamic name

Anonymous — Wed, 23 Mar 2016 08:57:29 GMT

I am not sure If I understood what you just explained.
What I want to do is just have as a filename one row from my tmap table, for example: "row1.id" . To do this do I have to edit the tmap settings or create something else like setglobalvar? Thanks.