Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Please Help me in below IF condition when ever all listed curriculum_title matches its returned as 'certified' ( and condition)
but i want 'or' condition any one of the curriculum_title matches and status matched then also i should get result as 'certified'
if(Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',
'Corporates Analyst and Associate Director',
'Covered Bonds Analyst and Associate Director',
'International Public Finance Analyst and Associate Director',
'Sovereigns Analyst and Associate Director',
'Structured Finance Analyst and Associate Director',
'Insurance Analyst and Associate Director',
'Fund and Asset Management Analyst and Associate Director',
'US Public Finance Analyst and Associate Director',
'Global Infrastructure Group Analyst and Associate Director') and CURRICULUM_STATUS= 'ACQUIRED','Certified')
please help me. how can i get same result if any thing matches in the list
Thanks
Damodhar
I believe your expression worked as OR condition also or you can try with
if(Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',
'Corporates Analyst and Associate Director',
'Covered Bonds Analyst and Associate Director',
'International Public Finance Analyst and Associate Director',
'Sovereigns Analyst and Associate Director',
'Structured Finance Analyst and Associate Director',
'Insurance Analyst and Associate Director',
'Fund and Asset Management Analyst and Associate Director',
'US Public Finance Analyst and Associate Director',
'Global Infrastructure Group Analyst and Associate Director') OR CURRICULUM_STATUS= 'ACQUIRED','Certified')
Hi
Match() returns an integer of the matching string, so you need to check it is > 0, as per below.
if( ( Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',
'Corporates Analyst and Associate Director',
'Covered Bonds Analyst and Associate Director',
'International Public Finance Analyst and Associate Director',
'Sovereigns Analyst and Associate Director',
'Structured Finance Analyst and Associate Director',
'Insurance Analyst and Associate Director',
'Fund and Asset Management Analyst and Associate Director',
'US Public Finance Analyst and Associate Director',
'Global Infrastructure Group Analyst and Associate Director') > 0 ) and CURRICULUM_STATUS= 'ACQUIRED','Certified')
if(Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',
'Corporates Analyst and Associate Director',
'Covered Bonds Analyst and Associate Director',
'International Public Finance Analyst and Associate Director',
'Sovereigns Analyst and Associate Director',
'Structured Finance Analyst and Associate Director',
'Insurance Analyst and Associate Director',
'Fund and Asset Management Analyst and Associate Director',
'US Public Finance Analyst and Associate Director',
'Global Infrastructure Group Analyst and Associate Director') and (CURRICULUM_STATUS= 'ACQUIRED' OR CURRICULUM_STATUS='Certified')
Try to use wildmatch instead of Match, do you use the formula in a expression?
Another one you try with
if( ( Match(CURRICULUM_TITLE , 'Financial Institutions Analyst and Associate Director',
'Corporates Analyst and Associate Director',
'Covered Bonds Analyst and Associate Director',
'International Public Finance Analyst and Associate Director',
'Sovereigns Analyst and Associate Director',
'Structured Finance Analyst and Associate Director',
'Insurance Analyst and Associate Director',
'Fund and Asset Management Analyst and Associate Director',
'US Public Finance Analyst and Associate Director',
'Global Infrastructure Group Analyst and Associate Director') OR CURRICULUM_STATUS='ACQUIRED') ,'Certified')