Name of the Output file must come from the column field
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The new column in the table will be the name of the file. How will I do that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
