How to output separate excel files based on values from a column dynamically

Question

Hi everyone, I have the following use case and unable to solve for how to output to separate files, especially if the number of files to be output can change. Below are two examples runs with the workflow, but as run 2 highlights the numbers of group can change/is variable so the workflow needs to be able to create/save new files accordingly each run and overwrite the old files to update with new data as well. Would greatly appreciate any help!

Run 1-

ValueGroup1ABAlpha2BCBeta3CDAlpha

Output-

Alpha.xlsx (Contains 1AB and 3CD)

Beta.xlsx (Contains 2BC)

Run 2-

ValueGroup1ABAlpha2BCBeta3FFAlpha4DEGamma

Output-

Alpha.xlsx (Contains 1AB and 3FF)

Beta.xlsx (Contains 2BC)

Gamma.xlsx (Contains 4DE)

jrlindem · Accepted Answer

Another option if the schema is the same, is you can use formulas to build out your output path and filenames dynamically.

Reference this other post:  Split file data by Account Lead - Alteryx Community and the responses there as well.  Here's the main parts (and attached):

You should be able to adapt to your need from there!  -Jay