Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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.

 

Macro.JPG

 

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

 

Workflow.JPG

 

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
AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes