Name of the Output file must come from the column field

[rtablate]

Hi, Good day1

I just want to ask how the value from the table is going to be my file name? See example below

I have this DateTime_Out column value is "November" data is changing by month so is the file name as well. So once I have the Output Data file name will be "Billing Details - November 2020" November from the file must come in the table value

[Aidan_K]

Hi @rtablate ,

Use formula tool to add a new column "filename". Build the filename as follows "Billing Details - "+[DateTime_Out]+".csv" and use the following configuration in the output tool (note the settings at the bottom of the screenshot are most important).

When the month changes now in column "DateTime_Out " the filename should change for you. If there is different values you will get a new file for each record.

Also attached is an example workflow .

Regards,

Aidan

[rtablate]

The new column in the table will be the name of the file. How will I do that?

[Jonathan-Sherman]

Hi @rtablate,

You'll want to create the file path in a formula tool

Selecting this new field in the bottom part of the output tool configuration pane "Take File/Table Name From Field".

Kind regards,

Jonathan

[Aidan_K]

Hi,

In the formula tool you can enter any value for the filename you like. I used the text you suggested initially as an example only (and included the field [date time_Out] to add the month. You can change the values between the first quotes (currently "Billing Details - ") to be anything you like. If you have a specific file location you want, add the full filepath before like "C:\temp\Billing Details - ".

Regards,
Aidan