Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Reading Multiple files and processing

I got the requirement to read the file with same structure from different path and different sheet, so I worked and identified a way to achieve this requirement.


Step 1: List the files that are required to read from the different path and create it Excel with the file name and respective path.


Source file.JPG


Step 2 : Create batch Macro give control parameter as filepath and mention the correct template.




Step 3 : Create a workflow add source input and Map Source file i.e. list of files with path.




Finally you can see the all the data are merged together write in your output as single file. You can additional transformation if you want process any business logic further and write in output.

Note: Adding additional file name source path will be enough for additional file processing.





1 Comment
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes