Rename an output file with the name of a variable (dinamic) and the current date

[Anonymous]

Dear all,

i need to rename an output (csv) file based on a variable that is inside the Job + the current date. An exemple of the output can be "markertId-ddmmyyyy" where markertId is the variable and ddmmyyyy is the date of the day.

Thanks for the help

[Anonymous]

I get the field "markertId" from the input file Excel. 

[javvaji]

In that case you will get number of output files is equal to number of "markertId" from input.

Ex : "markertId" count is 3 then you will get 3 output files.

Is this is the output you expected?

[TRF]

Replace the 1rst tFixedFlowInput by your tFileInputExcel.

For the 2nd tFixedFlowInput, you just have to define the schema depending on what you expect in the target output file then populate each field with the global variable defined by the tFlowToIterate as in the example I proposed.

Import the job I've attached to a previous answer and play with it, this is the best way to learn.

Also, don't forget to accept the solution as it solved your case (Kudo also accepted).

[Anonymous]

@javvaji Yes, that is what i expect. i have 3 (or more) different values and i would like to have 3 (or more) different files named like the values of the field markertId

[javvaji]

Then you need to use tFlowtoIterate component and need to iterate each value from input and should use the tFlowtoIterate global property and need to use it in output filename column in tFileOutputDelimited component.

[TRF]

@javvaji you should read previous replies...

[javvaji]

@TRF ya i know you have given answer, but still he asked right so i gave reply.

[Anonymous]

("row79.marketId")

Why do you have used row79.marketId?? because now the file have the date, but does not have the name of the field.

 

[TRF]

You have to change "row79" by your own "row name" depending on what it is in your job.

[Anonymous]

1)but, as you can see in the screen, there are no values but only the names of the fields. How i can import the values of the table?

2) i would like to replace row79 with the correct field but i don't find the correct field. where is it?

what setting i have to use? : - values

                                             - inline table 

                                             - inline content?