topic Re: Wild Match () in QlikView

Wild Match ()

madhavi_rajawat — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have one Field Say

Number

R*14W

S43W*

ABCDE

EFGHI

i want output only ABCDE,EFGHI

Re: Wild Match ()

sunny_talwar — Wed, 21 Jun 2017 15:26:10 GMT

Is this something you need in the script?

Re: Wild Match ()

sunny_talwar — Wed, 21 Jun 2017 15:27:41 GMT

Also look here

Find the value by using wild match

Re: Wild Match ()

zebhashmi — Wed, 21 Jun 2017 15:33:36 GMT

Try this

WHERE NOT EXISTS ("*");

SQL SELECT .....;

Re: Wild Match ()

vishsaggi — Wed, 21 Jun 2017 15:35:57 GMT

Or this? May be:

IF(FindOneOf(Number, '*') = 0, Number) AS NewNumber

LOAD *,

IF(FindOneOf(Number, '*') < 1, Number) AS Values,

FindOneOf(Number, '*') AS Num INLINE [

Number

R*14W

S43W*

ABCDE

EFGHI

];

Re: Wild Match ()

Anonymous — Wed, 21 Jun 2017 16:38:30 GMT

LOAD F1 Where Index(F1,'*')=0;

LOAD * INLINE [

R*14W

S43W*

ABCDE

EFGHI

];

Re: Wild Match ()

madhavi_rajawat — Thu, 22 Jun 2017 04:19:04 GMT

Yes I want to show value only without * ,Using wildMatch Function in Script

Re: Wild Match ()

sunny_talwar — Thu, 22 Jun 2017 13:51:14 GMT

Try like this

Table:

LOAD * INLINE [

Number

R*14W

S43W*

ABCDE

EFGHI

] Where Not WildMatch(Replace(Number, '*', '@'), '*@*');

Re: Wild Match ()

Anonymous — Thu, 22 Jun 2017 15:20:51 GMT

it works but I still don't understand why using wildmatch() for that filter...

Re: Wild Match ()

sunny_talwar — Thu, 22 Jun 2017 15:23:38 GMT

No idea... might be an interview question because there has been couple of request for the same scenario....

Re: Wild Match ()

Anonymous — Thu, 22 Jun 2017 15:26:26 GMT

perhaps the right answer then would be "forget it"