Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
ZIG
Contributor
Contributor

Exclude loading few rows based on a condition

I want to exclude loding those rows which has a value in a particular column, I have tried but it gives me error

I want to exclude those rows which has 'TTG_mm' present in the column - code
my load script code - 

[data1]:

LOAD *,

Rowno() AS FLAG_data1,

MonthName(date) AS Month_Year

FROM [lib:// filepath.csv]

Where not WildMatch(code, '*TTG_mm*');

drop field department_2, country_code, s_value;

can somebody please help me on this

Labels (1)
2 Replies
BrunPierre
Partner - Master II
Partner - Master II

How about this?

Where WildMatch(code, '*TTG_mm*') = 0;
vinieme12
Champion III
Champion III

can you post a screenshot of the error message?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.