How to use Directory input to read all the csv files from a folder?

Mayra2291

Hi everyone,

I'm using a wildcard in input to read all the CSV files from a folder, but it seems like the Alteryx scheduler does not find the file path when using a wildcard. I think a possible solution to make the scheduler work for this workflow could be to use the directory input tool with another tool to get all the CSV files. Does somebody know how to achieve this?

Thanks! 

Wildcard.png

Schedulem Path.jpeg

TheMattLeonard

Looking at the Schedulem Path.jpeg, I think your issue is that the file path in the Wildcard input is incorrect.

I believe it should be \\cascade\finance\Tableau\Photo2023\*.csv

However this method only works if your files all have the EXACT same format. Same number of columns, in the same spots, etc. If you have any variation you need to account for then yes, you will need to use the directory tool and an input macro, which is usually what I default to anyway.