Match Logic

[tmumaw]

Should this not work?

Thanks

if(Match(Opportunity.davey_HeaderCancelCode,'05','06','18','22','24','25','27') > 0,1,0) as HPermCancel,

[m_woolf]

Looks OK to me. What are the possible values for Opportunity.davey_HeaderCancelCode and what are you getting for HPermCancel?

[mdmukramali]

Hi,

can you try like below.

if(Match(Opportunity.davey_HeaderCancelCode,'05','06','18','22','24','25','27') ,1,0) as HPermCancel,

or

if(WlidMatch(Opportunity.davey_HeaderCancelCode,'05','06','18','22','24','25','27') ,1,0) as HPermCancel,

Thanks,

Mukram

[sunny_talwar]

It seems like it should work... basically you are assigning 1 for all those rows where Opportunuty.dabey_HeaderCancelCode = 05, 06, 18, 22, 24, 25, 27, right?

[tmumaw]

Yep

[sunny_talwar]

Don't see a reason for it to not work.... Is it not flagging anything with 1? or everything is flagged with 1? What is going on?

[tmumaw]

I am running it again to see what is flagged and what is not.  Will keep you posted thanks.

[tmumaw]

My test did not work.....any ideas....

[sunny_talwar]

What were the results? Without giving me more details, I would be throwing stones in the dark...

[tmumaw]

I am reading 2 different databases (Microsoft CRM and SAP) one is storing it differently than the other.  I will re-run in the morning and let you know the results.  Need to make a few changes and re-extract the data. Thanks