Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Change name of xlsx to date AND use multiple tabs

Highlighted
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.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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.

Highlighted
7 - Meteor

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

Labels