Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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