topic Re: ignore rows with certain data? in QlikView https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603932#M1105688 <HTML><HEAD></HEAD><BODY><P>thank you guys... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 20 Mar 2014 18:43:36 GMT 2014-03-20T18:43:36Z ignore rows with certain data? https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603928#M1105684 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have a csv file with two columns prodID, productname. Product ID is expected to be a number. But I have characters in few of the records coming from a source system. </P><P></P><P>How do I load only records with numbers in prodID?</P><P></P><P>Please help out.</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 20 Mar 2014 18:29:18 GMT https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603928#M1105684 2014-03-20T18:29:18Z Re: ignore rows with certain data? https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603929#M1105685 <HTML><HEAD></HEAD><BODY><P>LOAD ...</P><P>FROM File.csv</P><P>WHERE IsNum(prodID);</P></BODY></HTML> Thu, 20 Mar 2014 18:34:59 GMT https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603929#M1105685 Nicole-Smith 2014-03-20T18:34:59Z Re: ignore rows with certain data? https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603930#M1105686 <HTML><HEAD></HEAD><BODY><P>use if condition like below while loading</P><P></P><P>load if(isnum(ID),ID) as ID, field2;</P><P>load ID,field2 from abc;</P></BODY></HTML> Thu, 20 Mar 2014 18:36:16 GMT https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603930#M1105686 2014-03-20T18:36:16Z Re: ignore rows with certain data? https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603931#M1105687 <HTML><HEAD></HEAD><BODY><P>Try as below</P><P>L<SPAN style="font-size: 10pt; line-height: 1.5em;">oad .....</SPAN></P><P>From FileName</P><P>Where IsNUM(prodID);</P></BODY></HTML> Thu, 20 Mar 2014 18:37:26 GMT https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603931#M1105687 MK_QSL 2014-03-20T18:37:26Z Re: ignore rows with certain data? https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603932#M1105688 <HTML><HEAD></HEAD><BODY><P>thank you guys... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 20 Mar 2014 18:43:36 GMT https://community.qlik.com/t5/QlikView/ignore-rows-with-certain-data/m-p/603932#M1105688 2014-03-20T18:43:36Z