5 Replies Latest reply: Apr 12, 2012 9:07 AM by Ramon Hogervorst RSS

    Comparing new records with old ones

      Hi all,

       

      Please find the example as attached.

       

      Each SKUnr has a generic number, which means that the SKU creation and its numbers follow a chronological order (X2 is newer than X1).

       

      My goal:

      For each SKUnr a check should be done on previous SKUnrs. The first SKUnr is the first reference. There is a logic behind this:

      Does SKUnr have: \

           0. No reference --> display "0"

      1. new ProdGroup --> display “1”
      2. new Color --> display “2”
      3. new size --> display “3”

       

      When an expression can be formulated the result will be as follows (ExpressionCheck is the desired column with an expression):

       

      SKUnrProdGroupColorSizeExpressionCheck
      X1A1100
      X2A2102
      X3A1203
      X4B1101
      X5B1153
      X6B2152

       

      I really hope someone could help me, any help will be highly appreciated.

       

      Kind regards

      Ramon