(This was originally posted in the Knowledge Base but I think this is a better place to ask so I've moved it... Please pardon the confusion.)
Hi. Recently I need to do something similar to this knowledge article:
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Split-Output-Into-Multiple-Files-with-Specific-Record-Counts/tac-p/89321/jump-to/first-unread-message#M2210
but I ran into a problem. The example above is outputting to Alteryx database format. I'd like to output mine into multiple Excel files (not worksheets). But it gave me a "You must specify a sheet name error." I tried different combination of the "Output Options" and "Take File/Table name from field" and still to no avail. My setting is this:
Basically my data has a few hundred rows with 2 columns only, and I'd like to split it into some 20+ files according to the "Dept" field.
Many thanks in advance!
