Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Is it possible to create a field in Data Extension in ET/SFMC which is auto-incremented as the values are added to it?
There is a hidden auto-increment field _CustomObjectKey. I don't understand there are so many hidden things from document, that is very hard for partners and developers. Also if you use AMPscript, GUID() might help.
Unfortunately, there's no such datatype in SFMC.
I've used one solution for this.
Copied from one Data extension to another data extension. There I have used like:
Select *, _CustomObjectKey as ID from Dataextension1
This is working fine for me.
Required, but never shown