6 Replies Latest reply: Dec 4, 2013 12:26 AM by Jerry Tan RSS

    Keep adding N value group by dimensions

    Jerry Tan


      Hi All,

      I want to generate the TransactionNo which is it start from 0000000020 by ID. If there have the same ID, the TransactionNo will keep adding 20. On the other hand, it there have different ID, the TransactionNo will start again from 0000000020. Any idea for the scripting?

       

      The following is the example table for the scenario above:

       

      IDTransactionNoAccountNo
      000010000000020A100
      000010000000040A101
      000010000000060A102
      000010000000080A111
      000020000000020A112
      000020000000040A113
      000030000000020A114
      000030000000040A115
      000030000000060A116
      000030000000080A117

       

      Regards,

      Jerry