I am fairly new to KNIME and I need help extracting data from a table/matrix. I currently have a 100 x 100 .txt file of numbers ranging from 1-10 for each entry. I am interested in entries with values ranging from 1 to 5. Is there any way to use KNIME to find the row and column number for each entry corresponding to this criterion? I want to keep the original table intact. I just need to know where these entries are in the table based on their row and column number. I apologize if this is an ignorant question. I looked through the forums, but could not find a question asking this. I greatly appreciate your help!
An alternative is to use the Unpivot node to put all your table contents in one column, with the original RowIDs and ColumnIDs as the other two columns. Then you can follow this up with a Row Filter to get the values between 1 and 5, together with their respective positions.
(The Pivot/Unpivot nodes are extremely powerful and I seriously regret not learning them during my first few years with Knime)
This is exactly what I want! I’m having trouble getting the workflow to give the output I want. Could you help? I have attached screenshots of the workflow node settings below.
After including columns in “Column List Loop Start” node and applying the expression in “Column Expressions” node, you have to include only the column produced by Column Expressions node (I suggest to rename the column).