I’ve created a workflow that I’m testing now that incorporates new files every month and it seems to be working well except for one hitch – one of the input files I use (an Excel file which I receive from an outside source) has a different number of columns every month. I use the “Select” tool to bring in the data I need from this column, but I have to change the parameters in the Configuration Box for each month to capture the right column. The column is always the last column in the file I receive (it’s a sum of several columns in a row which represent different accounts) but it varies from column #28 to #38 or more in the months I’ve tested.
I’d like to get away from adding in the new input files and then changing the parameters in the “Select” tool every time, so that this can be a no-touch process. What is the best way, short of altering the file I receive prior to inputting, to capture the correct column every time, regardless of its location in the file?
