Row Number Custom Value also known as the ROW_NUMBER() in SQL allows you to create sequential numbers (eg. 1,2,3..) on each row of a Data Extension. The use of ascending (ASC) and descending (DESC) are also supported on this Custom Value.
Watch this video to learn more about Row Number.
How to create a Row Number Custom Value?
- Go to Custom Values section > Add new value button
- Provide a name for the Custom Value > Apply formula to a field > Click Next > Row Number > Click Next
- Select the Data Extension, the field, and either ascending or descending on how you want to start the subsequent numbering, e.g. in the case below, the numbering will start from the lowest CustomerId
- Save and drag-and-drop the new Custom Value to the Target Data Extension fields
Combine Customers and Vouchers Data Extensions to randomly match one voucher to a customer. Know that Customers and Vouchers Data Extensions have no matching column to combine them together.
Follow these step-by-step instructions to achieve this.
You can also create reusable Custom Values. Follow this link to learn how to create reusable Custom Values.