Adjusting Captions prior to Apply Map

[#1]

Hey Guys - I have the below, which works fine to apply most of the correct product names.  I want to be able to adjust a few of the Capt_US before the map is applied.   

CustomCaptions1:

Mapping LOAD

       "Capt_Code" as OppoProductMap, "Capt_US" as Product

SQL  SELECT...

Table:

Load

   if(Oppo_Product>0,

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

From

I tried putting:  if(WildMatch(Capt_US,'*Sage 100*'),'Sage 100') as Product; in the script but that removes all other product captions.

Any thoughts?

Best,

David

[rwunderlich · Accepted solution]

You are missing the "Else" in the if().

if(WildMatch(Capt_US,'*Sage 100*'),'Sage 100',ApplyMap('CustomCaptions1',Oppo_Product,)) as Product

It may be easier to adjust your mapping table to map that value directly.

-Rob

[#3]

Thanks Rob!  I did forget the else Capt_US at the end there. 

Changing the mapping table would be much easier, but I the company won't give me access to change tables in CRM.

[rwunderlich]

You don't need to change the CRM source table. You can make the adjustment when you create the mapping table.

CustomCaptions1:

Mapping LOAD

       "Capt_Code" as OppoProductMap,

    if(WildMatch(Capt_US,'*Sage 100*'),'Sage 100', "Capt_US") as Product

SQL  SELECT...

-Rob

[#5]

That is what I did. Sorry, I misunderstood!!!

All the best,

David