IF statement is returning null for the ELSE part

Nitaci — Fri, 18 Nov 2022 11:47:16 GMT

Dear All,

After joining two table with outer join, I need to create a new column (collumn 3) that copies another one (column1) but replace all the null values in (column1) with values in (column2).

My code looks something like:

Table1: Load Name, Column1 From [location1]; Outer Join(table1) Load Name, Subname, Column2 From [location1]; Table3: Load Column1 Column2 If(IsNull(Column2), Column1, Column2) as Column3 Resident Table1;

I get the correct result when Column2 is not null, but when it is null I get null and not Column2.

Screenshot:

Any suggenstions?

Re: IF statement is returning null for the ELSE part

BrunPierre — Fri, 18 Nov 2022 12:33:05 GMT

Try with this in place of the IsNull()

Len(Trim(Column2))= 0

Re: IF statement is returning null for the ELSE part

Nitaci — Fri, 18 Nov 2022 12:51:41 GMT

Great thanks!

topic IF statement is returning null for the ELSE part in Connectivity & Data Prep

IF statement is returning null for the ELSE part

Re: IF statement is returning null for the ELSE part

Re: IF statement is returning null for the ELSE part