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
14 - Magnetar
14 - Magnetar

@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