topic Re: Recode a column based on a second table in Discussions

Recode a column based on a second table

Benjamin_Fuerst — Thu, 08 Jun 2023 16:30:20 GMT

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

Re: Recode a column based on a second table

Bill_Worley — Thu, 09 Mar 2023 14:30:50 GMT

@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 table

Benjamin_Fuerst — Thu, 09 Mar 2023 15:29:48 GMT

Thanks Bill!!

The Join with match flag did the thing!