topic Re: Exclude Null Names on Matching in QlikView https://community.qlik.com/t5/QlikView/Exclude-Null-Names-on-Matching/m-p/622314#M229070 <HTML><HEAD></HEAD><BODY><P>you may try like below.</P><P>Load *, Applymap('AAA',name,'NULL') AS New11 </P><P>Inline [</P><P>name,&nbsp;&nbsp;&nbsp; code,&nbsp;&nbsp;&nbsp; Dept</P><P>Ron,&nbsp;&nbsp;&nbsp; 11,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa </P><P>,&nbsp;&nbsp;&nbsp; 11,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cc</P><P>John,&nbsp;&nbsp;&nbsp; 12,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ss</P><P>Rick,&nbsp;&nbsp;&nbsp; 13,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cc</P><P>] Where name&lt;&gt;'';</P></BODY></HTML> Wed, 26 Mar 2014 08:45:03 GMT sudeepkm 2014-03-26T08:45:03Z Exclude Null Names on Matching https://community.qlik.com/t5/QlikView/Exclude-Null-Names-on-Matching/m-p/622313#M229069 <HTML><HEAD></HEAD><BODY><P>Hi Community</P><P></P><P>See the Attachment for my Requirement.</P><P></P><P></P><P></P><P>Regards</P><P>Aviral Nag</P></BODY></HTML> Wed, 26 Mar 2014 08:27:27 GMT https://community.qlik.com/t5/QlikView/Exclude-Null-Names-on-Matching/m-p/622313#M229069 aveeeeeee7en 2014-03-26T08:27:27Z Re: Exclude Null Names on Matching https://community.qlik.com/t5/QlikView/Exclude-Null-Names-on-Matching/m-p/622314#M229070 <HTML><HEAD></HEAD><BODY><P>you may try like below.</P><P>Load *, Applymap('AAA',name,'NULL') AS New11 </P><P>Inline [</P><P>name,&nbsp;&nbsp;&nbsp; code,&nbsp;&nbsp;&nbsp; Dept</P><P>Ron,&nbsp;&nbsp;&nbsp; 11,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aa </P><P>,&nbsp;&nbsp;&nbsp; 11,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cc</P><P>John,&nbsp;&nbsp;&nbsp; 12,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ss</P><P>Rick,&nbsp;&nbsp;&nbsp; 13,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cc</P><P>] Where name&lt;&gt;'';</P></BODY></HTML> Wed, 26 Mar 2014 08:45:03 GMT https://community.qlik.com/t5/QlikView/Exclude-Null-Names-on-Matching/m-p/622314#M229070 sudeepkm 2014-03-26T08:45:03Z Re: Exclude Null Names on Matching https://community.qlik.com/t5/QlikView/Exclude-Null-Names-on-Matching/m-p/622315#M229071 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Find the attachment</P></BODY></HTML> Wed, 26 Mar 2014 09:37:46 GMT https://community.qlik.com/t5/QlikView/Exclude-Null-Names-on-Matching/m-p/622315#M229071 mangalsk 2014-03-26T09:37:46Z