In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Retrieve and join Mutiple files from 1 folder.

amorej
7 - Meteor

How do I retrieve and join mutiple files from 1 folder?

1 REPLY 1
Carolyn
12 - Quasar
12 - Quasar

Do you want to Join or Union them? Are the schemas the same? If you're wanting to Union with the same schemas, you can use a wildcard in the Input Tool. For what I have below, it'll import all files in that folder that are xlsx and have the same tab name (tab name not shown in the picture).   

 

2024-07-08_11-50-02.png

 

Edit: This flowchart might help. It talks about the different ways to import multiple files with minimal tools - https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

Labels
Top Solution Authors