how to use NOT Match function()?

[Sai_Mohan]

Hi Team,

I have a doubt in Qlik sense - Data Load editor.  I have a column named 'Target' in Data load editor which comes from SQL Query.

I need to exclude few values in that Column, so what i have to do is .. I need to create a excel file and  provide those excluded values there. Take that xlsx file into data load editor and have to give not match function, so that in report it has to remove those excluded values there.

In Data Load Editor: // getting values from SQL

Target_days:

Id,

name

Target;

LEFT JOIN (Target_Days)
LOAD
[Target Number] AS Target    // I have given same column name for alias so that values will match
FROM $(Target_File)   // Variable in which i have given location
(OOXML, EMBEDDED LABELS, TABLE IS Sheet1)
where Match ([Target Number]);-- Iam getting error here.   // How to give not match function

I need to exclude those two values here.

Please help ASAP

Thanks In Advance

[tamilarasu]

You can  try using where condition in sql load. Create a variable and include all your excluded values and use it in where condition.

[Sai_Mohan]

Thanks for replying @tamilarasu 

No they dont want me to give in sql load. They dont want to refresh all the data again and again just to adding this in where condition. 

So please help me with not match function in this. to exclude values

INNER JOIN (Target_Days)
LOAD
[Target Number] AS Target    // I have given same column name for alias so that values will match
FROM $(Target_File); // Variable in which i have given location
(OOXML, EMBEDDED LABELS, TABLE IS Sheet1);

[tamilarasu]

Can you try this?

Exclude:
Load
[Target Number] AS Target 
FROM $(Target_File)
(OOXML, EMBEDDED LABELS, TABLE IS Sheet1);

Target_days:
Load Id,
name
Target  where not exists (Target);
SQL Select *...

Drop table Exclude;