https://community.qlik.com/t5/QlikView/Load-how-to-exclude-certain-values-present-in-a-field-when/m-p/1879682#M1216801 <P>Bonjour,</P> <P>je cherche la syntaxe pour exclure certaines valeurs présentes dans un champ lors du chargement</P> <P>J'ai essayé ceci sans succès.</P> <P>SAT :<BR />LOAD<BR />ContactKey as KEY_REPONSE,</P> <P>...</P> <P>FROM<BR />[..\DATA\Data_Extract_Enquete*.csv]<BR />(txt, unicode, embedded labels, delimiter is ';', msq)</P> <P><STRONG>where ContactKey &lt;&gt; </STRONG><BR /><STRONG>'0030Y00000pzvJwQAI</STRONG><BR /><STRONG>,0031n00002Co5WdAAJ'</STRONG></P> <P>;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Merci</P> Fri, 07 Oct 2022 19:19:48 GMT François 2022-10-07T19:19:48Z https://community.qlik.com/t5/QlikView/Load-how-to-exclude-certain-values-present-in-a-field-when/m-p/1879682#M1216801 <P>Bonjour,</P> <P>je cherche la syntaxe pour exclure certaines valeurs présentes dans un champ lors du chargement</P> <P>J'ai essayé ceci sans succès.</P> <P>SAT :<BR />LOAD<BR />ContactKey as KEY_REPONSE,</P> <P>...</P> <P>FROM<BR />[..\DATA\Data_Extract_Enquete*.csv]<BR />(txt, unicode, embedded labels, delimiter is ';', msq)</P> <P><STRONG>where ContactKey &lt;&gt; </STRONG><BR /><STRONG>'0030Y00000pzvJwQAI</STRONG><BR /><STRONG>,0031n00002Co5WdAAJ'</STRONG></P> <P>;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Merci</P> Fri, 07 Oct 2022 19:19:48 GMT https://community.qlik.com/t5/QlikView/Load-how-to-exclude-certain-values-present-in-a-field-when/m-p/1879682#M1216801 François 2022-10-07T19:19:48Z https://community.qlik.com/t5/QlikView/Load-how-to-exclude-certain-values-present-in-a-field-when/m-p/1879761#M1216806 <P><STRONG>...</STRONG></P> <P><STRONG>where not Match(ContactKey,&nbsp;</STRONG><STRONG>'0030Y00000pzvJwQAI'</STRONG><STRONG>, '0031n00002Co5WdAAJ', '0032AnyOtherKey', '0033YetAnotherKey')</STRONG></P> <P>&nbsp;</P> <P>hope this helps</P> <P>Marco</P> <P>&nbsp;</P> Tue, 11 Jan 2022 19:42:53 GMT https://community.qlik.com/t5/QlikView/Load-how-to-exclude-certain-values-present-in-a-field-when/m-p/1879761#M1216806 MarcoWedel 2022-01-11T19:42:53Z https://community.qlik.com/t5/QlikView/Load-how-to-exclude-certain-values-present-in-a-field-when/m-p/1879933#M1216810 <P>It's OK&nbsp;</P> <P>thank you</P> <P>François</P> Wed, 12 Jan 2022 08:38:35 GMT https://community.qlik.com/t5/QlikView/Load-how-to-exclude-certain-values-present-in-a-field-when/m-p/1879933#M1216810 François 2022-01-12T08:38:35Z