We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

How to input files using the names generated in a directory component

jcastro
7 - Meteor

Hi community,

 

I would like some help.

 

Do I need to input files using the names generated in a workflow that uses the directory component?

 

Thanks!

 

5 REPLIES 5
mceleavey
17 - Castor
17 - Castor

Hi @jcastro ,

 

I'm not sure what the question is, but if you want to dynamically load in all files in a folder location, I've attached two tools and a worked example for you.

 

This loads in all tab names from all files in a location. It then creates a full path which then is fed into another tool which loads them all in. You can apply filters to remove tabs you don't want.

 

Hope this helps,

 

M.



Bulien

jcastro
7 - Meteor

I don't know if it was well explained! The list of files generated in the workflow output above should be used to input only those files from the list.

mceleavey
17 - Castor
17 - Castor

Ah, in that case, use the second tool (Input Multi-Schema Flat Files) and feed in the fullpath to the files you've created. This will be the data input and the control parameter value. In the "Questions" tab, select this fullpath field.

If you've got duplicate file names, simply use a sum tool to group by the full path field.

 

Hope this helps.

 

M.



Bulien

jcastro
7 - Meteor

@mceleavey

 

Thank you very much for the solution. Helped me a lot.

mceleavey
17 - Castor
17 - Castor

no problem.gif



Bulien

Labels