Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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.