I am strugging finding the right node that does value mapping.
I have these two tables:
and I want to map the value of table 2 into table 1, so that the output table looks like this:
in this case, which node I should use?
Thank you so much for your help
hi @HanhDo and welcome in the KNIME world
make sure that your second table is unique regarding to two columns “No” and “BS”.
Then use a Joiner node
with config “Left join”
and use your first table on the top and the second as bottom input.
Match the columns “No” = “No” and “BS” = “BS”.
That should attach the corresponding Service Value.
Hope, that helps, greetings,
you can use the joiner node as @tommy mentioned. But only use BS as key columns for joining.
@tommy: No represents only the row number e.g. BS for No. 5 is different.
Hi @tommy and @morpheus,
It workksss thank you so much for your help :).
@morpheus, you’re right! Thanks for reporting
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.