Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

Wild Match ()

Hi,

I have one Field Say

Number

R*14W

S43W*

ABCDE

EFGHI

i want output only ABCDE,EFGHI

10 Replies

Re: Wild Match ()

Is this something you need in the script?

Re: Wild Match ()

zebhashmi
Valued Contributor

Re: Wild Match ()

Try this

WHERE NOT EXISTS ("*");

SQL SELECT .....;


vishsaggi
Esteemed Contributor III

Re: Wild Match ()

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

];

robin_hausdoerfer
Valued Contributor III

Re: Wild Match ()

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

LOAD * INLINE [

    F1

    R*14W

    S43W*

    ABCDE

    EFGHI

];

Partner
Partner

Re: Wild Match ()

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

Re: Wild Match ()

Try like this

Table:

LOAD * INLINE [

    Number

    R*14W

    S43W*

    ABCDE

    EFGHI

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

robin_hausdoerfer
Valued Contributor III

Re: Wild Match ()

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

Re: Wild Match ()

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