topic Re: Wildcard Match in QlikView

Wildcard Match

mahendragaur — Mon, 12 Jun 2017 11:56:02 GMT

Hello All,

I have below script in which I used wildcards while loading data. Condition for [Phone No] is if it starts with 9 or 8 or 65 then that row should not be loaded. But, in below case data isn't getting loaded if [Phone No] field is blank. But I want blank [Phone No] field as well to be loaded.

LOAD Distinct

Upper(Name),

Upper(Date) ,

Upper(Address),

Upper([Phone No])

FROM

(qvd)

Where not WildMatch(Name,'*-*') and

not WildMatch(Date,'*-*') and

not WildMatch([Phone No],'9*','8*','65*');

Re: Wildcard Match

Anonymous — Mon, 12 Jun 2017 11:58:19 GMT

how about adding an OR condition checking if phone No is blank....

Re: Wildcard Match

RonaldDoes — Mon, 12 Jun 2017 12:06:03 GMT

Hi Mahendra,

WildMatch(Name,'*-*')

Are you sure you want to exclude all names containing a - (such as 'Ronald-Alexander').

If you were trying to exclude Nulls (displayed as "-"), you want to go with:

WHERE NOT ISNULL(Name) AND NOT ISNULL(Date)

Aside from that, I see no reason not WildMatch([Phone No],'9*','8*','65*') should prevent empty phone numbers from being loaded.

Re: Wildcard Match

kamal_sanguri — Mon, 12 Jun 2017 12:12:33 GMT

Use this:

LOAD Distinct

Upper(Name),

Upper(Date) ,

Upper(Address),

Upper([Phone No])

FROM

(qvd)

Where not WildMatch(Name,'*-*') and

not WildMatch(Date,'*-*') and

not WildMatch([Phone No],'9*','8*','65*')

and isnull([Phone No])

and len[Phone No])<1;

Re: Wildcard Match

mahendragaur — Mon, 12 Jun 2017 12:41:30 GMT

Hello Ronald,

yes this is correct WildMatch(Name,'*-*'). The only thing I also wonder why it is not showing value if [Phone No] is blank.

Re: Wildcard Match

mahendragaur — Mon, 12 Jun 2017 13:02:36 GMT

Thanks for your response but it is not working

Re: Wildcard Match

mahendragaur — Mon, 12 Jun 2017 13:04:38 GMT

Hello,

To make this easy to understand I'm attaching demo qvw as well as excel file.

Re: Wildcard Match

RonaldDoes — Mon, 12 Jun 2017 13:45:15 GMT

Hi Mahendra,

In that case, try:

Where not WildMatch(Name,'*-*') and
   not WildMatch(Date,'*-*') 
   and (not WildMatch([Phone No],'9*','8*','65*')
   or IsNull([Phone No]));