Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Outputting a .xlsx sheet with formulas to multiple, around 100, files in same location

gckplatt
6 - Meteoroid

Is there a way to add a sheet to with built in excel formulas to multiple files all located in the same location? Kind of like a directory input but for the output where the sheet would go out to all the .xlsx files in the folder.

2 REPLIES 2
BS_THE_ANALYST
15 - Aurora
15 - Aurora

@gckplatt please could you explain the problem again? 

 

All the best,
BS

LinkedIN

Bulien
gckplatt
6 - Meteoroid

Sorry, so I have a flow that is creating multiple sheets based off a column value using a formula and filepath tool. Then those multiple sheets are going in to multiple files ina n output based off the column value. Once the 100 files each with their multiple sheets are sent to the folder location I was wondering if I could create a new flow and input a summary tab with built in excel formulas and create an output that would send the sheet to all the 100 files in the folder location.

Labels
Top Solution Authors