Using Excel files that add and subtract columns

Hi Guys, I have a problem. One of my files I use in excel reader adds data every month and then restarts every fiscal year. How can I regularly change the files without having to change the column filter every month?

Could you just read the whole table? Assuming the changing data is in the columns?
Otherwise you might want to use “Read Excel Sheet Names (XLS)” and then the right one if the data is in sheets.

kn_example_excel_changing_columns.knwf (58.5 KB)

I basically only want to use the last column of the data.

You could extract the name of the last column and just keep that. And you could rename the column to something standard.

kn_example_excel_changing_columns.knwf (82.3 KB)