Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Union data from all files in a directory

L_Gordon
8 - Asteroid

How to union the data from multiple files in the same directory with the same schema.  There is only 1 worksheet in each file but the names are different,.

5 REPLIES 5
MatthewO
Alteryx
Alteryx

@L_Gordon you can accomplish this with the Dynamic Input tool.

binuacs
20 - Arcturus

@L_Gordon One way of doing this with the Dynamic Input tool

 

binuacs_0-1666821752086.png

 

grazitti_sapna
17 - Castor

@L_Gordon , Please find the below workflow, This workflow will be useful in all cases. Multiple workbooks with single or multiple sheets having same or different schema. You can use it for any case.

Sapna Gupta
bradleyareese
5 - Atom

Thanks!  This worked!

jackallen
5 - Atom

This was a lifesaver, thank you

Labels