match function

[#1]

Hi  guys

  i have a scenario like   below:

courseid={1,2,3,4,5,6,7,8,9,10}

If(Match(id,'1','2','3','4','5') ,'certified')

in the above condition  it will   return certi fied when ever  all  id's matches..  but  i want  result   any one  of the  match case also

mean-> 1 or 2 0r 3 or  4 or 5  also i should get  result "Certified"

please help me

[#2]

hi

PFA ...

Hope it satisfies your requirement

Vinayagam

[ashfaq_haseeb]

Hi,

try below

Load *,IF(Match(ID,1,2,3,4,5),'Certification','N/A') as CERTIFICATION;

LOAD * INLINE [

    ID,

    1,

    2,

    3,

    4,

    5,

    6,

    7

];

Regards

ASHFAQ

[Anonymous]

Hello,

Iam new to Qlickview and appreciate your help.

In the load script, i have the following  nested  If using Match function

If (match(LEGETYNACE7_BK,'6511001','6511002','7511001','7511006'), 'SOVEREIGNs-S7',

If(match(LEGETYNACE7_BK,'7511002','7511003','7511004','7511005','9112200'),'PSEs-S8',

If(match(LEGETYNACE7_BK,'6512101','6512102','6512103','6512104','9900301'),'FIN-INSTs-F1',

If(match(LEGETYNACE7_BK,'6512100','6512600','6512601','6512602','6512700','720302','6720303','7484702'),'OTHER-FIN-INSTs-F3',

If(match(CPT_LEID,'87431','322987','18820','60625698'),'SNEs-S6',

If(match(CPT_LEID,'18834','35534','18816','18849','82882'),'MDB-S3',

If(match(CPT_LEID,'11187','87667','10796','10879','10802','10867','603950'),'GSEs-F5'))))))) as Counterparty

It is displaying the  first 4 .It is not displaying 'SNEs-S6', 'MDB-S3','GSEs-F5' under Counterparty.

Your help is highly appreciated.

Regards,

Paul