8 Replies Latest reply: Mar 3, 2016 3:24 PM by Sunny Talwar RSS

    Wildmatch or Like function?

    Yvonne Han

      Hi

       

      I'm trying to map a field "seller risk" to a "Highest risk" field.

      The seller risk's value has multiple seller and their risk, for example "Apple - Low; Microsoft - Medium; Nokia - High"

      The Highest risk field should take the highest risk of all sellers' risk and in this example, it should be "High"

      I'm trying to use the wildmatch function, but looks like it doesn't work.  Any idea how to map this?

       

      Thanks

       

      Yvonne

       

      This is my script:

      Load [seller risk],

      if(wildmatch([seller risk], 'High'),'High',
      if(wildmatch([seller risk], 'Medium'),'Medium','Low')) as [Highest Risk]