Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
oliveton
Creator
Creator

Use Script to Remove all Parts Ending With 'VR'

Hello,

I want to remove all numbers in my load that end with 'VR' I want to remove the whole number, not just the VR suffix.

I've tried using "where not" (below) and I keep getting an error saying %MahleCram can't be found. But it does not work when I use its previous name XCLEVITEM either.

Does anyone have a solution?

Thank you !!!

3 Replies
PabloTrevisan
Partner - Creator II
Partner - Creator II

Hi Natalie,

you can try this function on the code:

where right(%MahleCram,2) <> 'VR'

But in a resident load, in this where clause only XCLEVITEM is valid.

dapostolopoylos
Creator III
Creator III

Use this:

Where

     not WildMatch(Text(PurgeChar(PurgeChar(XCLEVITEM, ' '), '-')),'*VR')

Father/Husband/BI Developer
oliveton
Creator
Creator
Author

Hi Pablo,

I tried this but all my parts that end with "VR" still appear.

Is there something I'm doing wrong ?