0 Replies Latest reply: Sep 1, 2010 5:09 PM by danhilz RSS

    Creating a New/Change flag field in a Change Log load script


      I need to place a new/change flag or autonumber count in a new field when the word REV appears for the second or more time in a Change Log table.
      This flag needs to be place in a load script so other calculations can be done.
      Below is how the output should look. Any help or ideas would be great.

      Example: Change Log Example with (new field)

      Invoice #1, Detail ID#1, Type=REV, (new field) = 1 or New
      Invoice #1, Detail ID#1, Type=OTHER, (new field) = 0
      Invoice #2, Detail ID#36, Type=REV, (new field) = 1 or New
      Invoice #3, Detail ID#44, Type=REV, (new field) = 1 or New
      Invoice #3, Detail ID#45, Type=OTHER, (new field) = 0
      Invoice #3, Detail ID#53, Type=REV, (new field) = 2 or Change
      Invoice #4, Detail ID#55, Type=REV, (new field) = 1 or New