topic Re: Omitting certain string descriptions from a field. in QlikView

Omitting certain string descriptions from a field.

Thu, 14 Nov 2013 08:39:02 GMT

Hello there folks,

I am trying to figure something out here, I would like to remove all descriptions from a field which starts with the character '.' and '-'.

I have tried the below script but failed badly, could anyone point me in the right direction or advise on what am doing wrong here.

Table_A:

Load

[Country],

[Date],

[BrandDesc]

from ....

where [BrandDesc] <> '.*' and [BrandDesc] <> '-*';

Thanks in advance.

Best Regards,

Ram

Re: Omitting certain string descriptions from a field.

tresB — Thu, 14 Nov 2013 08:41:40 GMT

Use WildMatch() function. Like:

Table_A:

Load

[Country],

[Date],

[BrandDesc]

from ....

where Not WildMatch([BrandDesc], '.*' , '-*' );

Re: Omitting certain string descriptions from a field.

Sokkorn — Thu, 14 Nov 2013 08:42:11 GMT

Hi Ram,

Are you load data from QVD? If yes, then try

Where not WildMatch([BrandDesc],'.*','-*');

Re: Omitting certain string descriptions from a field.

Thu, 14 Nov 2013 08:48:45 GMT

Thanks! Spot on.

Re: Omitting certain string descriptions from a field.

Thu, 14 Nov 2013 08:49:07 GMT

Thanks! Spot on.

Re: Omitting certain string descriptions from a field.

Thu, 14 Nov 2013 08:51:00 GMT

Hi,

If you only want to remove these description but keep the rest of the fields for each record of the table I suggest using the following:

Table_A:

Load

[Country],

[Date],

If(not( Left([BrandDesc],1)='.') or not( Left([BrandDesc],1)='-'), [BrandDesc] ,null()) as [BrandDesc]

from ...;

Regards

Re: Omitting certain string descriptions from a field.

Thu, 14 Nov 2013 09:24:10 GMT

Thanks!