Hi All,
I have a column below with just 1 dates for all rows.
Id like to grab the date and use it as filename.
Please help me with this, thank you.
12/15/22
Hi @ericren
You can use a workflow like this one to do that:
1) I used the formula tool to build the filename (it is without specifying the folder, so it will save at the same location of the workflow)
2)Inside of the output tool, you can configure it to take the filename from your the column generated by the above formula:
Choose the "Replace FileName with group" option
Click the field to group on drop down also.. are there any columns that appear there?
You can use a join tool right (joining the column with file name) towards the end in order to have a field with file name to choose from.
Check out the Dynamic Input tool. Under the Developer tab, single-left-click the Dynamic Input tool, click Open Example, run the sample workflow, and review the sample output.
You may need to also use a Formula tool to incorporate your date into a text string like a Full Path (folder name and file name), going into the Dynamic Input tool.
Here's the Tool Mastery article: https://community.alteryx.com/t5/*/*/m-p/24946
And the Tool Mastery index: Tool Mastery Index - Alteryx Community
Chris
I am rendering a basic table. How am I able to incorporate the date?
Using your same example, here it is:
Using the render tool you dont need to specify the sheet. It is like this:
Hi Sorry, here is what I am working with. Where does the formula go? I cant use the formula tool from the layout. And it wont connect from the original intput.
Hi Felipe,
In my Render table, I'm referencing an excel output file that has data in it. When I run the script, my file get's renamed correctly but my data gets replaced by the data in the render table. How do I keep the data from my original excel output file?
Thanks,
Steve