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

[javvaji]

For the values you need to use ctrl+space then you will able to see the properties of tFlowToIterate_1 component and there you will find the property name with the column name  as input column name.

Ex : ((String)globalMap.get("row1.dateTime"))

[Anonymous]

ok. now the name of the output file is correct, the problem is that the 3 files generated are without records. And i think the problem is that i dont know how i can retrieve the values of the fields

[TRF]

You should trace the content after tFileInputExcel and before tFileOutputDelimited to verify the flow content (tab Debug Exec then Trace Debug).