Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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
Partner - Master

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.