Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What where statement can I use to not load data that starts with a tilde?
Where NOT Left(SourceName,1) = '~'
Where NOT Left(SourceName,1) = '~'
Thank you it works great.
Please mark the right answer as "right answer", not yours!!
Sorry about that but not sure how to uncheck the wrong correct answer and check the correct one?
Hi Gysbert,
I also have a similar problem in my case i don't want "undefined" data from my filter , i just altered your code above but am getting error, Please see the attached screenshot. can u help me on this?
A Where clause can't be used in a chart expression, only in load statements in the script.
And "undefined" is 9 characters long, not 1. So you need to use 9 as the second parameter in the Left function.
Thank you Gysbert !!