If match AND Match AND NOT Match

[saiyashwan]

I try to use this to create service column and but not all the values are getting populated ..and and not match condition value '0' getting displayed .. Any insight would really helps

 if (match(Record_Type, ‘Authorized' AND Match(Sub_Type,'Appeal' )), 'Research' ,
if (match(Record_Type, 'PA'), ‘Determination' ,
if (match(Record_Type, ‘Information'), ‘Info',
if (match(Record_Type, 'Verification' ), 'Verification's',
if (match(Record_Type, ‘Authorization' AND NOT Match(Sub_Type,'Appeal' )), ‘Pre-Determination',
if (match(Record_Type, 'General’ AND Match(Sub_Type,'General Inquiry' )), ‘ Manager Inquiry',
if (match(Record_Type, 'Inquiry' AND Match(Sub_Type,'Detailed Inquiry' )), ‘Case Reviews',
if (match(Record_Type, 'Potential' ), Quality Report',
if (match(Record_Type, 'Commercial’), ‘ Assistance Program Enrollment',
if (match(Record_Type, ‘Step 1' AND Match(Sub_Type,'Coverage Follow Up' )), ‘Site of Care Follow up',
if (match(Record_Type, 'Copay' AND Match(Sub_Type,'New' ) ) ,'Pharmacy Activation' , '0'))))))))))) AS Service

[Vegar · Accepted solution]

It looks like you have a bunch of misplaced parentheses.

You code:
if (match(Record_Type, ‘Authorized' AND Match(Sub_Type,'Appeal' )), 'Resea....

Should probably look like this:
if (match(Record_Type, ‘Authorized' ) AND Match(Sub_Type,'Appeal' ), 'Resea...

Am I correct? If so then you have this syntax misspelling in multiple locations in your expression.

[Vegar · Accepted solution]

I also notice incorrect use of  ‘ ’ where you should be using ' '.

[Haldeman14]

Well a simple error in use of single inverted comma...Just rectify it and your problem should be solved.I hope u r very much clear now 

[jonathandienst · Accepted solution]

Like this:

if (match(Record_Type, 'Authorized') AND Match(Sub_Type, 'Appeal'), 'Research',
if (match(Record_Type, 'PA'), 'Determination' ,
if (match(Record_Type, 'Information'), 'Info',
if (match(Record_Type, 'Verification' ), 'Verification's',
if (match(Record_Type, 'Authorization') AND NOT Match(Sub_Type, 'Appeal'), 'Pre-Determination',
if (match(Record_Type, 'General') AND Match(Sub_Type, 'General Inquiry'), 'Manager Inquiry',
if (match(Record_Type, 'Inquiry') AND Match(Sub_Type, 'Detailed Inquiry'), 'Case Reviews',
if (match(Record_Type, 'Potential'), Quality Report',
if (match(Record_Type, 'Commercial'), 'Assistance Program Enrollment',
if (match(Record_Type, 'Step 1') AND Match(Sub_Type, 'Coverage Follow Up'), 'Site of Care Follow up',
if (match(Record_Type, 'Copay') AND Match(Sub_Type, 'New'), 'Pharmacy Activation' , '0'))))))))))) AS Service

[saiyashwan]

Thanks.. this solved the issue