first of all, I am quite new at KNIME. Just working with it for one year. Now, I have a task, I am not able to solve without any help. Maybe you can give me some good hints?
I have kinda data pool with multiple .xlsx-files (with different and inconsistent names). I want to create a KNIME workflow with a permanent loop over this folder to writeall of the necessary information of those Excel-files into a database. I have done it with a "List File"-Node and a "Generic Loop Start" ... So the loop works quite good to me...So far so good.
But in this folder, there are multiple, different processes which has to be written in different database tables (.xlsx-files) and I need to figure out which database table is the right to write the data in. For example:
xlsx-file A: FILE1 --> database table 1 (Process 1)
xlsx-file B: FILE2 --> database table 2 (Process 2)
xlsx-file C: FILE3 --> database table 1 (Process 1)
The only way to find a consistent way to write the data in the correct database table could be based on a comparison of the column header. I want to check the column header out of a table (read with the XLS-Reader). For example and in addition to the upper case:
FILE1: column header: A, B, C, D
FILE2: column header: A, B, D, E, F
FILE3: column header A, B, C, D
I don't find a way to realise this with KNIME. Is there any option to solve my problem?
If you would share your knowledge with me, I would be super glad.