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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
sushantk19
Creator
Creator

Running sequence number while implementing SCD2

How to implement Running Sequence Number(Auto increasing) like Skey from SCD component.

 

Presently I have used the below logic:

Numeric.sequence("row1.id",1,1)

 

But this always start from 1 if i run my job again, causing duplicate in Skey values. Please suggest.

Labels (2)
10 Replies
sushantk19
Creator
Creator
Author

Please ignore the below scenario. There was a bug in my code which has been corrected now.

The below condition is correct:

 

Numeric.sequence("s1",context.max_id,1)