Recode a column based on a second table

[#1]

Hello community,

I already thought a while and searched here about my problem.

I have a primary table with IDs and information. With the help of a second table (contains only a part of the primary table) I would like to create a column in the primary table with a "label" for those IDs which are only present in the second table.
Please have a look at my screenshot. I think that will give a clearer picture of what I need.

Thanks in advance for an idea!
Ben

[#2 · Accepted solution]

@Benjamin_Fuerst 

I would recommend you try both Tables > Join with a Match Flag and Concatenate with a Source Column to see if one of those operations gets you closer to what you want.  You may need to adjust the order of the values, but you will get a label either way.

HTH

Bill

[#3]

Thanks Bill!!

The Join with match flag did the thing!