6 Replies Latest reply: Apr 10, 2018 1:16 PM by Erica Trotter RSS

    Duplication when creating Matching Dimension

    Erica Trotter

      In the script I am creating a variable that indicates if two fields match:


          If(

          Match([Encore.License_Number], [Workday.License_Number]),'Match Encore', 'Does Not Match')

              as Match.License_Number,

          If(

          Match([Encore.License_Class], [Workday.License_Class]),'Match Encore', 'Does Not Match')

              as Match.License_Class


      The issue I am having is if there are multiple it doesn't match correctly:

      Capture.PNG


      Please let me know if you can help, thanks in advance!