Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies