Autonumber in Marketing Cloud?

I am currently building a smartcapture form. It is capturing new contacts to be stored in a data extension in marketing cloud. It takes their name, email address etc. I also want it to assign them a unique number as a secondary personal id (email address is used as primary key and subscriber key).

Is there a way?

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

There’s no auto-numbering in SFMC.

You have a few options:

You can assign them a GUID with the NewID() SQL function in a Query Activity.

You can reference the hidden _CustomObjectKey column in a Data Extension. It’s a unique number assigned to each row. It is not always sequential and does not start at 1.

You can use a ranking function in SQL to assign a number to each row:

select
  x.emailaddress
, x.insertDate
, x.idNum
FROM (
 select
    s.emailaddress
  , s.insertDate 
  , row_number() over (order by s.insertDate desc) idNum
  from signupform s
) x

Either way, you’ll need to run a Query Activity on your captured data to populate it.

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0