ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Reading Files output from directory tool

hkein1
7 - Meteor

I have the following workflow where I use a directory and filters to get the designated files I'd like to look at data. How can I then append all the data in these files into a single sheet?

alteryx ss.PNG

MarqueeCrew
19 - Altair
19 - Altair

@hkein1,

 

You're looking to use the DYNAMIC INPUT tool.  Here's a quick video of mine that illustrates alternative approaches (you might want to subscribe to me on youtube).

 

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
hkein1
7 - Meteor

For the Input Data Source Template selection with dynamic input, how am I able to select the files from the directory tool I'm using?

MarqueeCrew
19 - Altair
19 - Altair

@hkein1,

 

Given that the schema for each file is the same, select the first 1 or 2 rows of data from one file and save that to a "Template.csv" file.  Then use that template in the dynamic input tool.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
dpcurtis
7 - Meteor

Can you share the file? I am looking for the details of how to process the directory output and read the files in it.

Labels