Combining multiple columns into one new column, while keeping the original column

Question

I have below table, where I am trying to merge the columns in yellow in one column, while maintaining the original columns; the data in the highlighted yellow columns is populated based on the interaction type they fall into if the interaction type is null that means it doesn't fall into the interaction type category:

Would appreciate any help or guidance on how I can approach this

Expected outcome:

One new column that combines information from all six columns only if its not null, I have added another screenshot above for expected outcome — NewCode, Dec 23 '20 at 20:42

score 1 · Accepted Answer · answered Dec 23 '20 at 20:45

This looks like coalesce():

select t.*,
    coalesce(
        svc_proc, 
        interest, 
        transtypekey, 
        connectivity_name, 
        vm_entreprise_program,
        channels
    ) as interaction_details
from mytable t

coalesce() returns the first non-null value of the arguments list.

Combining multiple columns into one new column, while keeping the original column

1 Answers1