Hi all!
Is there any way to extract a column from multiple tabs and multiple spreadsheets where the spreadsheets may have varying numbers of tabs with different names for the tabs?
Say I have 3 spreadsheets with varying numbers of tabs - and what I want to do is extract one column (the column location is always the same and has the same name) from some of the tabs in each spreadsheet. I then want to transpose each column to a row and then copy and paste each row to a new spreadsheet. In each spreadsheet, the tabs have different names, but they consistently have some tabs called “Info”, “Factories”, “Warehouses”.
So I would want to read all 3 spreadsheets from the folder, and then say, take column J (for example) and transpose to new spreadsheet for all spreadsheets, for every tab in those spreadsheets where the name IS NOT “Info”, “Factories”, “Warehouses”.
I think this might be too much for KNIME’s basic operations - but thought I’d ask, if you need some visualised data examples or further explanation, I can expand (but hopefully the theoretical explanation is enough to say whether it is even feasible or not).