topic Use Script to Remove all Parts Ending With 'VR' in QlikView

Use Script to Remove all Parts Ending With 'VR'

oliveton — Tue, 24 Jul 2018 12:02:08 GMT

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 !!!

Re: Use Script to Remove all Parts Ending With 'VR'

PabloTrevisan — Tue, 24 Jul 2018 12:14:21 GMT

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.

Re: Use Script to Remove all Parts Ending With 'VR'

dapostolopoylos — Tue, 24 Jul 2018 12:21:06 GMT

Use this:

Where

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

Re: Use Script to Remove all Parts Ending With 'VR'

oliveton — Tue, 24 Jul 2018 14:05:03 GMT

Hi Pablo,

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

Is there something I'm doing wrong ?