Hello, I run a workflow daily that feeds 4 separate tabs into an existing excel output file. Each of the tabs has the same format and the last column in each tab will have a different output and that day's date, as below:
Tab 1 | Tab 2 | Tab 3 | Tab 4 |
Last Column Name | Last Column Name | Last Column Name | Last Column Name |
ABCD 22May | EFGH 22May | IJKL 22May | MNOP 22May |
ABCD 22May | EFGH 22May | IJKL 22May | MNOP 22May |
ABCD 22May | EFGH 22May | IJKL 22May | MNOP 22May |
ABCD 22May | EFGH 22May | IJKL 22May | MNOP 22May |
ABCD 22May | EFGH 22May | IJKL 22May | MNOP 22May |
ABCD 22May | EFGH 22May | IJKL 22May | MNOP 22May |
I want to set up the flow so that the 4 new tabs I send into the output file are named "ABCD 22May" "EFGH 22May" etc.
Right now I'm doing this manually by selecting "Create New Sheet" in the output options in the output data configuration box, and then in the "Write to File or Database" section I manually changing the name of the existing tabs from the previous day's tab names to the new name I want. Meaning, I will change the existing tab named "ABCD 21May" in the output file to "ABCD 22May"
How do I get my new tabs to name themselves automatically?
Thanks for any help you can provide.
Solved! Go to Solution.
thanks, that worked!