Discussion Board for collaboration related to QlikView App Development.
I have below two tables. Table1 and Table2. After I loaded the data, Qlikview auto joined the tables using the key.
Qlikview joined the table using the key.
Question here - If I want the null field in Column2 replaced with the value "C" in Column1. How can I replace the value and achieve below result?
(ooxml, embedded labels, table is Sheet1);
Left Join (tmp)
(ooxml, embedded labels, table is Sheet2);
,If(Len(Trim(Column2)) = 0, Column1, Column2) as Column2
DROP Table tmp;
And the results:
Pay attention that you will be left with only one table.
View solution in original post