no load data that starts with a tilde?

[#1]

What where statement can I use to not load data that starts with a tilde?

[Gysbert_Wassenaar · Accepted solution]

Where NOT Left(SourceName,1) = '~'

[#3]

Thank you it works great.

[rbecher]

‌Please mark the right answer as "right answer", not yours!!

[#5]

Sorry about that but not sure how to uncheck the wrong correct answer and check the correct one?

[#6]

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?

[Gysbert_Wassenaar]

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.

[#8]

Thank you Gysbert !!