Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What are the sult and Re in your values? Where this data coming from. Would you explain little more
hi Harasawa,
give a try at the below link
Replace function: Find Multiple strings and replace to blank
Try these in your Load script where you getting those field names
LOAD ....,
IF(NOT Match(Year, 'sult'), Year) AS NewYear,
IF(NOT Match(MonthNames, 're'), MonthNames) AS Month
FROM yousource;
I believe it is from this. This is at the very end but has no values
Can you share your actual script for those fieldnames?
You'll want to remove those records from your data. I'm guessing besides your month and year filters you have an extra 'results' row that doesn't belong.
In your script you'll want to add a where clause to remove it.
Something like
Load *
From YourFile
where not wildmatch(Month,'Res')
;