Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

wildmatch

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') & '*';

    T:

    load Distinct

    NOM_GROUPE,

    REF_GROUPE

    FROM

   

    (qvd)

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

    ;   

    let i = i+1    ;

loop

;

9 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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

alexandros17
Partner - Champion III
Partner - Champion III

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

Kushal_Chawda

try,

let i = 1;

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

do while i <= 50000

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

    T:

    load Distinct

    NOM_GROUPE,

    REF_GROUPE

    FROM

   

    (qvd)

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

    ;  

    let i = i+1    ;

loop

;

sasiparupudi1
Master III
Master III

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

qlikviewwizard
Master II
Master II

Hi AdamiSliu

Please attach some sample data. Thank you.

Not applicable
Author

Not applicable
Author

qlikviewwizard
Master II
Master II

hi AdamiSliu

What is this?