Primary key should be increment sequentially like HDFC001, HDFC002, HDFC03......

[Sathyam_Chandan]

Dear Community leaders,

Primary key should be generate sequentially. If I use autopk="true", it is incrementing randomly not sequentially. can you please which is the best way to generate unique primary key sequentially like below screenshot.

Regards

Satya

[Craig_Thonis · Accepted solution]

Hi Sathyam,

Please look at the thread below, which covers incremental logic and explains that the incremental increase isn't incrementing by 1 because the original logic was in place to jump by 30 or so to lower the risk of duplicate IDs.

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/autopk-in-the-sche...

If you need to change this logic then you will need to define your own sequence.

Regards,

Craig