Dataload question - IF statement

[jerryr125]

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

[Arthur_Fong · Accepted solution]

Try this:

if(isnull([Field01]),[Field02],[Field01]) as [Field03]