CSV Dynamic Input Files - Same Workflow and Separate Sheets for Output

[macst245]

Background on project: I have 23 separate excel CSV files in a folder in a directory, and each file only has one sheet which is the name of the file itself.  I.E. File name is ABCDE and the only sheet on that file is also ABCDE.

Purpose for using Alteryx: I have a workflow that works with a single file at a time, with no output (more on this below) and I want to be able to use this workflow for the above 23 separate excel and have them inputted into a workflow and worked on separately.

Output from Workflow: After the 23 separate files are inputted into the workflow and run through separately, I would need the outputted results to be combined into one excel file with the separate tab names after the input file.  I.E. The output tab for input file ABCDE should also be ABCDE.

I have attached my original workflow that works with a single inputted file.  

[fmvizcaino]

Hey @macst245 ,

I think we can use your workflow and include a few improvements in it.

1. I would try to use comma as a delimiter instead of \0 and load all the files at once, using *.csv
   1. If you need to use text to columns and dynamic rename, we can clean the headers from the other files with a filter
   2. I would select the 'output filename as field' option
2. In the summarize tool, I would include the filename as a group by
3. Instead of an append tool, I would use a join tool with the filename as a keyfield

I think this works, but of course, I based everything in a workflow with no data, so I could be wrong.

Best,

Fernando Vizcaino

[macst245]

Thanks for your help with this, is there any way you can help with the last portion about outputting all the files into one new spreadsheet on separate tabs?  Also, is there any way you can share a workflow with what you described above?

Thanks again!

[fmvizcaino]

Hey @macst245 ,

Would you mind sending a sample of your input, then I can build something that works 100%

Best,

Fernando Vizcaino

[macst245]

have attached a small sample in a ZIP file as this is how the files come into me and I'll be running the workflow from there, hope this helps!  

[macst245]

In addition, I wanted to make sure that the workflow is processed separately for each input file, but the output from those workflows are are to be saved into one excel file with the tabs being named after the input file names.  Hope this helps clarify what needs done in this instance.