Alteryx Designer Discussions

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

Want to take multiple csv file from folder to dynamic input

5 - Atom

Hi All,

 

Let me share you scenario:

 

i have one folder in which have multiple csv file . From database i got directory path and using formula tool to find multiple file with pattern * then i need to concat.

 

now i want to used dynamic input to combine data.

 

does someone have solution please reply . Will be appreciate if you share workflow file.

Alteryx
Alteryx

Hi @nomeshwary 

 

I have built a macro that should make this much more straight forward.

 

There is an example in the zip folder on the post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Batch-Macro-AKA-the-Extra-Dynami...

5 - Atom

Dear joe,

 

i want to get multiple file of same naming convention using formula tool and then use dynamic input tool to read data from that all file

Alteryx
Alteryx

Hi @nomeshwary 

 

I think what you'll need to do is get to a list of data files that you want, in separate rows, and then input it into my macro.

 

Do you have an example that you can upload?

Labels