Use simple workflow on multiple files in same folder with separate outputs

Hi all,

I have a simple workflow that inputs a CSV file, then outputs it as xlsx, using one of the field values to split data onto different tabs. I would like to use this workflow on many identical-schema CSV files in a folder, outputting each file separately.

I can't seem to figure it out using macro tools or Directory and I'm stumped. Is there a way to do this in Alteryx? I can attach my little workflow if needed.

Thank you!

Input

Output

Accepted answers

echuong1

See attached. You'll need to change the directory path in the first tool, as well as the output path in the formula tool within the macro.

New Workflow1.yxzp

All comments

joshuaburkhow

One way you can do it is use wildcards in your input. Here is a great quick tutorial on how to do that

https://www.youtube.com/watch?v=1y1gFXDkYwA

jcholet

Thanks for the response! That does a great job of importing them all. Can I use wildcards to output individual files? It is combining them all into one file but I need separate files.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703