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

    Wildmatch or Like function?

    Yvonne Han



      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?






      This is my script:

      Load [seller risk],

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