Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Change name of xlsx to date AND use multiple tabs

m1ngle74
7 - Meteor

tl;dr I can write to multiple tabs and I can assign today's date to output file. Can I do both for the same file so that I end up with 1 file called "Output 2019-11-3.xlsx" with three tabs?

 

First, I am writing an xlsx file with three tabs. I've successfully used the formula command to add a column called "Sheet Name", checked the "Take File/Name From field" button, selected the Change File Name dropdown, and then used the Block until done tool to write to multiple sheets. This works for as many sheets as I want to add.

 

m1ngle74_4-1572806919607.png

m1ngle74_0-1572806176158.png

The client is requesting the file also have the date stamp in the name, which I've ALSO done by using a formula tool to add a "sheet name" formula of "Outfile "+DateTimeFormat(datetimetoday(),"%Y_%m_%d"). This generates a file named "Outfile 2019-11-3.xlsx. Then I use the the following

m1ngle74_3-1572806699452.png

 

I have tried adding a "Block until done" tool at the end of this, but it just generates two files, one with three tabs and one with the date in the name of the field.


Does anyone know if I can create one file with three tabs and the date in the suffix of the name?

I hope this is clear.

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @m1ngle74 you need to combine the Filename and sheet name into one column and then use that column in your output. I mocked up and example and attached.

m1ngle74
7 - Meteor

Thank you, Joseph. This gave me the blueprint I needed. Much appreciated.

Labels