This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is it possible to rename your files? e.g. 1_Jan, 1_Feb, etc... 2_July, 2_Aug, etc...? If so then you could gather them using a wildcard, and use dynamic input to do one read... here's a mock up (where I had files named accordingly in the test path shown).
Sometimes I make my workflows "dumber" in order to accomplish things like this. First I would create a new field that numbers the months so they're in order. 01-Jan, etc (could use a lookup table for this). Then, using either a lookup table or a formulaic filter, I would just tell Alteryx if 1-6 then semester 1 else semester 2. If you need portions of those semesters it's not too hard to make a lookup table that has fields for 12 mo, 9 mo, 6 mo, etc.
I actually was just struggling with this using Tableau and finally decided it's faster to just do it the old fashioned way... make a date table and then make fields like Last 12 wks (Y/N), Last 4 weeks (Y/N).
While it builds my skills better to try to figure out a way to do this stuff programmatically, as @JohnJPS has done, if you're in a time crunch, I find it sometimes helps to make things less automated.
@JohnJPS and @cbridges beat me to it, but I just added a text input tool to handle the translation and used a dynamic input to read all the files. I passed the output filename as a variable.
This is assuming that all your input files have the same column names, otherwise you will get all the columns in all your outputs (which would have nulls). If you have different column names, a batch macro which housed the input and output would work. Hope it helps!
It makes sense to keep things stupid instead of making everything automated. In fact, finally i kept my same workflow repeated to my test, even it is a little bit ugly.
You know what, as a chinese i find sometimes automation will reduce the employment rate and that's why china have powerful technique but we try keep things in manual, such as the gas station, supermarkets