Excel Output to Current Date with Data in 3 sheets

Hello,

I have data being split into 3 different sheets of a single excel file. I am able to write to a static excel file (by naming sheets in the excel file) with 3 different tabs created, however I want the "excel" (not csv please) output in todays date and my data still being split into the 3 sheets within that file.

Output

Date Time

Accepted answers

JosephSerpis

The blog shows how to make a dynamic field filepath in the formula tool to be used in the Output Data tool with the option of Take file from field name so in your case the filename plus the date which you can use datetimenow() function. Yes the screenshot shows its a yxdb was just showing the option you need to select. However by building your filepath with a formula tool before the output data tool and using the option of take filename from field should give you the output you want. I mocked up an example.

Output_28092020.yxmd

atcodedog05

Trying using relative path instead of absolute path.

I.e just a file name format instead of whole path

And save the workflow where you want the file to be outputted

Hope this solves

If not please provide some screenshots or the issue and path formula used

I can help you out

All comments

JosephSerpis

Hi @danishrizvi you would need to utlise Take File/Table Name from field and use a field with the file name and date included within that field that you with this option in the Output Data tool.

I wrote a blog you might find helpful to understand on how to use this option.

danishrizvi

1 - The screen shot you have attached is outputting data to yxdb. I want the output to an excel file.

2 - Your blog talks about ouputting to 3 different sheets but looses the point of the excel file being named to current date.

3 - My main point is to have my data in 3 different sheets (static sheet names - Summary, Raw Data, Business Days) with the excel being named with the current date and the file name changes everyday with the change in the date. Really appreciate your response. Thank you.

atcodedog05

Hi @danishrizvi

Check the below link.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Copying-All-Sheets-from-a-Repository-to-Excel-Split-Files-Issue/m-p/640873#M146526

If you can share a sample file. I can prep up a workflow for you which will output file with filename or todays date.

Mention the desired filename format too.

danishrizvi

@atcodedog05 thank you for throwing a little more light with that link.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280