Hello all, I am attempting to load 72 .csv files into Alteryx. They all have identical naming conventions and data structure. However, over the 15 years the data has been gathered there have been new columns added incrementally. If I load the newest files first, alteryx just assigns null values to the older files. This is exactly the behavior I want. However, I would like to reduce my use of file input tools within the workflow. Ideally I would like to be able to load all the files using a relative path ex. servername/foldername/datafile*.csv
When I attempt this Alteryx loads the files in ascending order by file name. Is there a way to reverse this? Load all files by file name descending? Is there any way to control the load order at all?
Thank you!
