Remove Records from QVD

[#1]

This is so simple yet I can't get it to remove records when loading a QVD. In the QVD there is a field "CustomerName", when I load the QVD I want to remove any records where the CustomerName contains the word "sample" no matter where it is located in the string. I have tried WHERE CustomerName <> '*sample*', WHERE CustomerName Not Like '*sample*' and others with no luck. What am I doing wrong?

Thanks,

Stephen

[erichshiino · Accepted solution]

Try:

WHERE substringcount( CustomerName, 'sample')=0

[stevedark]

Hi Stephen,

The substringcount function will do the trick, as will index.  Be aware though that this will cause the QVD to load in a non optimized mode.  For a one of cleaning of your QVD this is fine, but if it is something you need in production then you should create a separate field in the QVD on creation called IsSample or something and then do a WHERE EXISTS on that.

Search the community for Optimized QVD Load and you should find plenty of articles.

- Steve

[#4]

Thanks Erich and Steve. The substringcount worked. Depending on what we are using the table for, sometimes we need the 'Sample' accounts sometimes we don't.

Stephen