Column mapping

Hi everyone,

I am strugging finding the right node that does value mapping.
I have these two tables:
image

and
image

and I want to map the value of table 2 into table 1, so that the output table looks like this:
image

in this case, which node I should use?

Thank you so much for your help
Best

hi @HanhDo and welcome in the KNIME world :slight_smile:

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,
Tommy

3 Likes

Hi @HanhDo,

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.

BR

3 Likes

Hi @tommy and @morpheus,
It workksss :smiley: thank you so much for your help :).
Best
HanhDo

@morpheus, you’re right! Thanks for reporting :slight_smile:

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.