topic Creating a New/Change flag field in a Change Log load script in QlikView https://community.qlik.com/t5/QlikView/Creating-a-New-Change-flag-field-in-a-Change-Log-load-script/m-p/184385#M502441 <HTML><HEAD></HEAD><BODY><P><BR />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.<BR />This flag needs to be place in a load script so other calculations can be done.<BR />Below is how the output should look. Any help or ideas would be great.</P><P>Example: Change Log Example with (new field)</P><P>Invoice #1, Detail ID#1, Type=REV, (new field) = 1 or New<BR /> Invoice #1, Detail ID#1, Type=OTHER, (new field) = 0<BR /> Invoice #2, Detail ID#36, Type=REV, (new field) = 1 or New<BR /> Invoice #3, Detail ID#44, Type=REV, (new field) = 1 or New<BR /> Invoice #3, Detail ID#45, Type=OTHER, (new field) = 0<BR /> Invoice #3, Detail ID#53, Type=REV, (new field) = 2 or Change<BR /> Invoice #4, Detail ID#55, Type=REV, (new field) = 1 or New</P></BODY></HTML> Wed, 01 Sep 2010 21:09:09 GMT 2010-09-01T21:09:09Z Creating a New/Change flag field in a Change Log load script https://community.qlik.com/t5/QlikView/Creating-a-New-Change-flag-field-in-a-Change-Log-load-script/m-p/184385#M502441 <HTML><HEAD></HEAD><BODY><P><BR />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.<BR />This flag needs to be place in a load script so other calculations can be done.<BR />Below is how the output should look. Any help or ideas would be great.</P><P>Example: Change Log Example with (new field)</P><P>Invoice #1, Detail ID#1, Type=REV, (new field) = 1 or New<BR /> Invoice #1, Detail ID#1, Type=OTHER, (new field) = 0<BR /> Invoice #2, Detail ID#36, Type=REV, (new field) = 1 or New<BR /> Invoice #3, Detail ID#44, Type=REV, (new field) = 1 or New<BR /> Invoice #3, Detail ID#45, Type=OTHER, (new field) = 0<BR /> Invoice #3, Detail ID#53, Type=REV, (new field) = 2 or Change<BR /> Invoice #4, Detail ID#55, Type=REV, (new field) = 1 or New</P></BODY></HTML> Wed, 01 Sep 2010 21:09:09 GMT https://community.qlik.com/t5/QlikView/Creating-a-New-Change-flag-field-in-a-Change-Log-load-script/m-p/184385#M502441 2010-09-01T21:09:09Z