Hello. I made a workflow that automatically reads all xls’ in a folder without having to specify where the data starts. Just point at folder with files and it combines them all. It does so by ignoring any rows that only have the first two columns filled out and then assigns the first row as the header. I would like to make it dynamic with an if switch to use the file reader when the extension is csv. I could do it in code but don’t understand how to do that with the knime switch nodes.
The workflow also allows merging of columns that have different names using a Table Creator to fields to be renamed so the files are concatenated correctly. So if your files are very similar and you want to merge some fields, it is easy. I can share it once I refine it a bit since it is slow when using big datasets. Maybe someone wants to make it into a functioning node, I don’t know how to configure the wrapper node to create settings.