How to dynamically change both excel file name and sheet name

Pandey19

Hi,

I've one excel input file like 11-2021_Analysis.xlsx and i want to generate my output file with name like 11-2021_Analysis.xlsx and it will have multiple sheets inside it. All the sheets will be prepended with 11-2021_Analysis .

This file name changes every month. So outputs should also change automatically.

Is it possible to do in Alteryx.

11-2021_Analysis.xlsx

JosephSerpis

Yes in the Input Data tool configuration you can select the option filename as field so the name of the file can become a field in your data running through your workflow. Then in the Output Data tool you can take filename from field to generate your file. You will need to use a formula tool to generate the file name with the different sheets based on your data. I've attached an example to this post

Filepath_29112021.yxmd