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