topic Populating Nulls when using left join in QlikView https://community.qlik.com/t5/QlikView/Populating-Nulls-when-using-left-join/m-p/188936#M52014 <HTML><HEAD></HEAD><BODY><P>I am trying to ginf the best way to populate a field when using a left join.</P><P>If the field in the right hand tabel is blank, it is then to be populaetd with one of the fields of the left hand table.</P><P>I can do this by reloading the table after running the join by using code such as :</P><P>Load IF(isNull(field),table1field,field) from resident table x;</P><P>I was wondering if ther is anotehr way of doing this without having to relaod the table.</P><P></P></BODY></HTML> Mon, 22 Mar 2010 16:04:39 GMT alan_grn 2010-03-22T16:04:39Z Populating Nulls when using left join https://community.qlik.com/t5/QlikView/Populating-Nulls-when-using-left-join/m-p/188936#M52014 <HTML><HEAD></HEAD><BODY><P>I am trying to ginf the best way to populate a field when using a left join.</P><P>If the field in the right hand tabel is blank, it is then to be populaetd with one of the fields of the left hand table.</P><P>I can do this by reloading the table after running the join by using code such as :</P><P>Load IF(isNull(field),table1field,field) from resident table x;</P><P>I was wondering if ther is anotehr way of doing this without having to relaod the table.</P><P></P></BODY></HTML> Mon, 22 Mar 2010 16:04:39 GMT https://community.qlik.com/t5/QlikView/Populating-Nulls-when-using-left-join/m-p/188936#M52014 alan_grn 2010-03-22T16:04:39Z