Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try using where condition in sql load. Create a variable and include all your excluded values and use it in where condition.
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);
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;