Using both ApplyMap and WildMatch

[#1]

I am getting an error on the below -- > ODBC read failed

if(Oppo_Product>0,

    WildMatch(Oppo_Product,'*"mas90"*'),'Sage 100'),

    WildMatch(Oppo_Product,'*"mas200"*'),'Sage 100',

    WildMatch(Oppo_Product,'*"13"*'),'Sage 100',

    WildMatch(Oppo_Product,'*"SageX3"*'),'Sage ERP X3',

     ApplyMap('CustomCaptions1',Oppo_Product,) as Product, 

The Mapping Table works without the WildMatch, but why not with it?  I can't access the original mapping table.  Is my best bet to just create a new mapping table and use that?

Can you not use WildMatch and ApplyMap for the same field?

[danieloberbilli]

I think the problem is a wrong If-clause structure: you already close the if-clause with the last bracket in the second line...I guess that's not intended? Would you like the applymap to be applied on the updated labels created by Wildmatch?

[danieloberbilli]

Maybe you are looking for something like this: