If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Table A has fields Col1 and Col2 that is pulled using a left keep to Table B. The common field between the 2 tables is Col1.
There are some Col1 that are present in Table B but missing in Table A. I want all Col1 in Table B to have a row in Table A. Those that do not have a row will have Col2 as NA.
Can someone help me please. Thank you.
can u try some what like below:
dim:LOAD * Inline [id,dept1,asd];
Fact:LOAD id,'n/a' as dept;LOAD * Inline [id,name,sal1,as,1002,we,200] Where not Exists(id,id);
Right Keep(dim)Fact1:LOAD * Inline [id,name,sal1,as,1002,we,200
View solution in original post