Re: Recode a column based on a second table@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
Re: Recode a column based on a second tableThanks Bill!!
The Join with match flag did the thing!
Recode a column based on a second tableHello 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

Mass CustomizationWindows