creating new column based on null and non null values of existing column

Question

Hi Community,

I'm having column A which has null values and non-null values and I want to create column B. Can you suggest me formula for that?

If isnull(col A) THEN (col B)  = 'Web' ELSEif  (col A)='1111' then (col B)  = 'Mobile' elseif (colA) ='2222' then (col B)  ='IPAD' else (col B)  = 'SOURCE UNKNOWN' ENDIF

Is the above formula right? can someone tell me the right formula? I'm attaching the excel file as well. Thank you

null_col_to_newcol.xlsx

michelle_mathews · Accepted Answer

Hi @srk0609 , the formula for Column B would be as follows. Ensure that Column A is datatype string for this formula to work.

if isnull([col A]) then "Web" elseif [col A]="1111" then "Mobile" elseif [col A]="2222" then "IPAD" else "Source Unknown" endif

PanPP · Accepted Answer

Hi @srk0609

I have provided a sample WF that shows the formula you are trying to use.

Hope this helps.

Felipe_Ribeir0 · Accepted Answer

Hi @srk0609

You can use this one. Just be sure that your col A field is a numeric field. If it is not, then the 1111 needs to be '1111', 2222 needs to be '2222'....

If isnull([col A]) THEN 'Web' 
ELSEif [col A] = 1111 then 'Mobile'
ELSEif [col A] = 2222 then 'IPAD'
ELSE 'SOURCE UNKNOWN' 
ENDIF