We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Is it possible to quickly connect to multiple data sources?

ralimar
5 - Atom

I'm working with lots of daily reports each contained in an individual file, and want to quickly input all the data, create a union, and output the consolidated file. Is there a faster way to do this than using the "input data" tool for each file?  

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @ralimar it is possible this guide outlines some approaches using excel files however the theory could be used for other file types. Without know more about your specific use case its hard to provide more advice.

Qiu
21 - Polaris
21 - Polaris

@ralimar 

If the files are saved in same location, we can then use the Directory Tool and Dynmic Input tool to put them in by specifying the file type.

@JosephSerpis 
Nicely summaried post. Thank you for the information.

 

Qiu_0-1626217158161.png

 

Labels
Top Solution Authors