topic Re: wildmatch in QlikView

wildmatch

Tue, 21 Jul 2015 10:39:44 GMT

The goal is to find the rows including the values in NAME,

the wildmatch don't work in this case, please help me to correct it? Thank you very much!

TN:

LOAD

NAME

FROM

(qvd)

WHERE len(NOM_GROUPE) = 0;

let i = 1;

//set iend = 50000; //NoOfrows(TN);

do while i <= 50000

let NCom = '*' & peek(NAME, $(i), 'TN') & '*';

load Distinct

NOM_GROUPE,

REF_GROUPE

FROM

(qvd)

where wildmatch(NOM_GROUPE, $(NCom) )=1

;

let i = i+1 ;

loop

;

Re: wildmatch

alexandros17 — Tue, 21 Jul 2015 10:45:38 GMT

Use Exists in this way:

TN:

LOAD

NAME

FROM

(qvd)

WHERE len(NOM_GROUPE) = 0;

load

NOM_GROUPE,

REF_GROUPE

FROM

(qvd)

where exists(NAME, NOM_GROUPE)

let me know

Re: wildmatch

Tue, 21 Jul 2015 10:48:06 GMT

I'm sorry, what I want is NAME include NOM_GROUPE or NOM_GROUPE include NAME, not the same.

Re: wildmatch

alexandros17 — Tue, 21 Jul 2015 10:54:12 GMT

Ok,

then how many NAME you have from TN Table?

If you have not lots of names then you can concat NAME into a string then compare this string to the NOM-GRUPPE into the second load directly, without any loop

Re: wildmatch

Kushal_Chawda — Tue, 21 Jul 2015 10:58:09 GMT

try,

let i = 1;

//set iend = 50000; //NoOfrows(TN);

do while i <= 50000

let NCom = peek(NAME, $(i), 'TN') ;

load Distinct

NOM_GROUPE,

REF_GROUPE

FROM

(qvd)

where wildmatch(NOM_GROUPE, '*$(NCom)*" )=1

;

let i = i+1 ;

loop

;

Re: wildmatch

sasiparupudi1 — Tue, 21 Jul 2015 11:31:53 GMT

It is hard to say why the wildmatch wouldnt work without looking at your data. could you upload a data sample may be?

Re: wildmatch

qlikviewwizard — Tue, 21 Jul 2015 14:16:13 GMT

Hi AdamiSliu

Please attach some sample data. Thank you.

Re: wildmatch

Tue, 21 Jul 2015 14:21:40 GMT

Recherche

Re: wildmatch

Tue, 21 Jul 2015 14:21:45 GMT

Recherche

Re: wildmatch

qlikviewwizard — Tue, 21 Jul 2015 14:23:51 GMT

hi AdamiSliu

What is this?