so i have a problem here where i need to add a Value according to 2 IDs one being a person in each line and the other being a column, i made a small one to serve as an example Knime teste.knwf (24.0 KB)
on the first image i have a value on row 2 (ID 1) of 7,273.66
i need that value to be on the image 2 on row 2 (according with the ID 3) column 3 (according with ID1)
and that for every value
if it helps the names of the colums do not matter as long the value matches with the ID by row and column
thank you for your time
Hi,
I think you are looking for the Joiner node. You join the tables by ID and in the column selection you can choose to only keep the “pay in” column from the top table. Also, you can first filter the top table to only keep rows where the “pay in” has a value by utilizing the Missing Value node.
Kind regards,
Alexander
that was what i feared with the actual document being so big i will have to do each column separately and the “pay out” also comes in play later in the document so i wanted to see if using the columns could help, still understandable and thank you for the help
