https://community.qlik.com/t5/QlikView/how-to-remove-value-not-required/m-p/1640179#M731726 <P>Perhaps this?</P><P><STRONG><SPAN>Load IDNo from table where not wildmatch(IDNo, '333*', '777*')</SPAN></STRONG></P> Mon, 28 Oct 2019 02:48:14 GMT Anil_Babu_Samineni 2019-10-28T02:48:14Z https://community.qlik.com/t5/QlikView/how-to-remove-value-not-required/m-p/1640177#M731725 <P>Hello There,</P><P><FONT face="trebuchet ms,geneva">I create some report that some data start at 333 and 777 is unwanted or not required my concern is how can i remove at IDNo field start at 333 and 777 in my load script, list below is my sample data from db.</FONT></P><TABLE><TBODY><TR><TD><STRONG>IDNo</STRONG></TD></TR><TR><TD>777abcdefg00000654349</TD></TR><TR><TD>853abcdefg00000614349</TD></TR><TR><TD>072abcdefg10000647350</TD></TR><TR><TD>802abcdefg10000064951</TD></TR><TR><TD>333abcdefg10000064356</TD></TR><TR><TD>333abcdefg10000064382</TD></TR><TR><TD>777abcdefg10000064358</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Best Regards,</P><P>Bing</P> Sat, 16 Nov 2024 02:06:29 GMT https://community.qlik.com/t5/QlikView/how-to-remove-value-not-required/m-p/1640177#M731725 bsbernabe 2024-11-16T02:06:29Z https://community.qlik.com/t5/QlikView/how-to-remove-value-not-required/m-p/1640179#M731726 <P>Perhaps this?</P><P><STRONG><SPAN>Load IDNo from table where not wildmatch(IDNo, '333*', '777*')</SPAN></STRONG></P> Mon, 28 Oct 2019 02:48:14 GMT https://community.qlik.com/t5/QlikView/how-to-remove-value-not-required/m-p/1640179#M731726 Anil_Babu_Samineni 2019-10-28T02:48:14Z https://community.qlik.com/t5/QlikView/how-to-remove-value-not-required/m-p/1640181#M731727 <P>Thank you for fast support highly appreciated.</P> Mon, 28 Oct 2019 03:11:17 GMT https://community.qlik.com/t5/QlikView/how-to-remove-value-not-required/m-p/1640181#M731727 bsbernabe 2019-10-28T03:11:17Z