Column mapping

[HanhDo]

Hi everyone,

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

and

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
Best

[tommy]

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

Joiner

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

[morpheus]

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

[HanhDo]

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

[tommy]

@morpheus, you’re right! Thanks for reporting