topic How to filter certain data in columns in the Load Editor in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-filter-certain-data-in-columns-in-the-Load-Editor/m-p/1267412#M2555 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to limit some of the data that I am loading. I have a column that has Test such as ELA Test 01, Math Test 01, etc... I want to make sure I only bring the ELA tests so not sure what it should be.</P><P></P><P>I am used to using </P><P>WHEN MATCH ([column], 'a','b','c')</P><P>but is there such a thing as </P><P>WHEN contains ([column], ELA)</P><P></P><P>Also, will there be a way to do a boolean when it contain ELA or English</P><P></P><P>I have tried looking for a place with the the scrip, but I cant find it anywhere.</P><P></P><P>Thanks,</P><P></P><P>Sara</P></BODY></HTML> Tue, 31 Jan 2017 18:15:53 GMT 2017-01-31T18:15:53Z How to filter certain data in columns in the Load Editor https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-filter-certain-data-in-columns-in-the-Load-Editor/m-p/1267412#M2555 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to limit some of the data that I am loading. I have a column that has Test such as ELA Test 01, Math Test 01, etc... I want to make sure I only bring the ELA tests so not sure what it should be.</P><P></P><P>I am used to using </P><P>WHEN MATCH ([column], 'a','b','c')</P><P>but is there such a thing as </P><P>WHEN contains ([column], ELA)</P><P></P><P>Also, will there be a way to do a boolean when it contain ELA or English</P><P></P><P>I have tried looking for a place with the the scrip, but I cant find it anywhere.</P><P></P><P>Thanks,</P><P></P><P>Sara</P></BODY></HTML> Tue, 31 Jan 2017 18:15:53 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-filter-certain-data-in-columns-in-the-Load-Editor/m-p/1267412#M2555 2017-01-31T18:15:53Z Re: How to filter certain data in columns in the Load Editor https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-filter-certain-data-in-columns-in-the-Load-Editor/m-p/1267413#M2556 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P><SPAN style="font-size: 13.3333px;">&nbsp; Wildmatch([column], '*ELA*','*English*')&gt;0 as _ElaEnglishBoolean</SPAN></P><P>FROM/RESIDENT</P><P>&nbsp; YourTable</P><P>WHERE</P><P>&nbsp; Wildmatch([column], '*ELA*')</P></BODY></HTML> Tue, 31 Jan 2017 18:41:16 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-filter-certain-data-in-columns-in-the-Load-Editor/m-p/1267413#M2556 Vegar 2017-01-31T18:41:16Z