Hi There,
I am a beginner to Alteryx, I have a work-flow which is producing 4 different outputs, all in .xlsx format.
I am trying to add a date to my outfile :
For instance: My current outfile is abc.xlsx how can I produce abc 02112020.xlsx ? An output file should include today's date each time work-flow is run.
Any advise or help is much appreciated.
Solved! Go to Solution.
This post might help you. The only change you need to do in the format is replace %Y-%m-%d with %d%m%Y to get the desired date format.
Hi @Nikhil86
Here is a workflow for the task. Always names latest date.
Output:
Workflow:
Output tool config:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
This is actually putting date within the Sheet . I was looking to have the data on my output file name , Maybe I am doing something wrong?
This is how I have configured ! But I am not getting todays date appended to my output file name ie Fixed Income_Upload.xlsx
Hi @Nikhil86
Can you run this workflow and tell me is it working?
I will definitely help you to fix it.
Hi @Nikhil86 I amended the workflow and from your screenshot you are missing the file/folder location or the output. You need the entire location of the file that is going to be outputted for this method to work. Therefore all of that syntax you masked in red in the screenshot needs to be incorporated with the formula tool with the filename.
Hi @Nikhil86
Glad to hear it got solved 🙂
You are allowed to mark multiple posts as solution. Since i solved a part of your task (date aprt) and Joseph solved a part of your task(path part). Can i request you to mark one of my posts as solution.
Happy to help 🙂
Cheers and Happy Analyzing 😀