1 Reply Latest reply on Dec 16, 2014 3:01 PM by philmodjunk

    Unique Records

    jwshelton22

      Title

      Unique Records

      Post

      I have thousands of records for hundreds of Users. A found set of records may have the same user name and login name, but a different workforce. The workforce is the difference.

      Some records have the login and other data brought in via an import, other records have the data entered via a calculation. The field data entered by the calculation is not being recognized as the same. Example:

      C237 is read differently than C237. If I use a replace contents the data is all viewed as the same and the calculation below works. What is wrong?

      I created a field named "flag_Unique" with the calculation:

      Let ( x = GetNthRecord (Login Copy ; Get(RecordNumber) - 1 ) ;

      If (Login Copy <> x ; 1 ; "" )

      )   //   end let