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