Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Creator III
Creator III

Dataload question - IF statement

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

1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this:

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

View solution in original post

1 Reply
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this:

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