04-12-2017 07:55 AM
I wonder could I get some help on the following. I have two existing character variables which are both ids. One is a product of method a while the other is a product of method b.
I would like to create a third variable which takes the accurate matches from both. A simple table illustrates my point.
Also where we have a contrasting match this output is placed in a second variable.
|ID1||ID2||Final id||Second Id|
Any help would be great!
04-12-2017 08:12 AM - edited 04-12-2017 08:14 AM
Look at the IFC function.
Or in Query builder, created a new column. You can use a CASE statement in your computed column.
04-12-2017 09:32 AM
It sounds like some simple logic would do.
if ID1=ID2 then Final_id = ID1;
else if ID1='xxxx' then Final_id = ID2;
else if ID2 = 'xxxx' then Final_id = ID1;
Final_id = ID1;
Second_id = ID2;
Optionally, if you really want to, you could add:
if Second_id = ' ' then Second_id = '-';