Dataload question - IF statement

jerryr125 — Thu, 31 Oct 2019 23:33:17 GMT

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

Re: Dataload question - IF statement

Arthur_Fong — Fri, 01 Nov 2019 01:03:05 GMT

Try this:

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