Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about this?
Where WildMatch(code, '*TTG_mm*') = 0;
can you post a screenshot of the error message?