Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Sai_Mohan
Contributor III
Contributor III

how to use NOT Match function()?

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

 

 

Labels (2)
3 Replies
tamilarasu
Champion
Champion

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
Contributor III
Contributor III
Author

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
Champion
Champion

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;