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

[jcastro]

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!

[mceleavey · Accepted solution]

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.

[jcastro]

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 · Accepted solution]

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.

[jcastro]

@mceleavey

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

[mceleavey]