Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - I have two fields in my data load and I would like to combine them into one field.
I would like to create a new field (Field03) and populate the Field03 with the following logic:
If Field01 is null then use the value in Field02 else use the value in Field01
any thoughts ? Jerry
Try this:
if(isnull([Field01]),[Field02],[Field01]) as [Field03]