So I have a table with column input1 and input 2.
Then I have a matrix table with column A to column D and rows from 1 to 4.
Now I want KNIME to check input 1 value in the matrix rows and the input 2 value in matrix columns. The result should then be the table entry there. I have added the expected results in the screenshots. So it is quite simple. check row, check column give me the result…
Hello Hans,
thanks for your help. yes you are right input1: 4 and input2: C should result in ce.
Unfortunately I am already struggling by getting the Matrix table into KNIME. I should have been more detailed with my example.
How can I import the follwoing table:
Is it possible to import PIVOT tables or those kind of tables?
The values in the first row of the Pivot table are strings with no order but they are all different.
After I have the above table in KNIME available the program should check each row of input 1 and 2 regarding their values in the Matrix table and give me the expected results.
So for the first step can upload your data (sample file / dummy data), to tackle the first step: getting the matrix into KNIME. Maybe a part of the solution can be found by reading in your data from some format into KNIME.
For the people at KNIME Forum it is very helpfull to work with an uploaded datastet, instead of creating it by ourself .