Pick and Match on multiple columns not working for below code

[hrithikroshan]

LOAD
[Risk Impact],
[Risk Likelihood],
pick(Match(
([Risk Impact]= 1 and [Risk Likelihood] =1),
[Risk Impact] = 1 AND [Risk Likelihood] =2),'low','high') as calc
FROM
[D:\Risks.qvd]
(qvd);

i am not getting the expected output kindly see the attachment, if risk impact and likelihood is 1 then i should get low and if risk impact is 1 and likelihood is 2 then i should get high but i am getting wrong results kindly suggest what i am doing mistake in this code

[Taoufiq_Zarra]

Hi,

'Pick', I don't think it's being used in its role if I understood your need correctly.

try this simple formula in the script:

if(([RISKIMPACT]= 1 and [RISKLiKELIHOUD] =1) or ([RISKIMPACT]= 1 and [RISKLiKELIHOUD] =2),'low','high') as NEW_CALC

I think that's the expected result.

Regards,

Taoufiq

[hrithikroshan]

I am using lot of If conditions in my logic and i need to replace multiple if's with pick and match .

for sample purpose i just mentioned only few if conditions

i need to use pick and match only for this requirement

[tresesco · Accepted solution]

Try like:

pick(Match( -1,
([Risk Impact]= 1 and [Risk Likelihood] =1),
[Risk Impact] = 1 AND [Risk Likelihood] =2),'low','high') as calc

[hrithikroshan]

Perfect answer thanks for your kind time