Row Number Custom Value
This feature is available on Unaric Segment Plus and Advanced.
Row Number Custom Value (that is translated as 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.
To learn how to use this Custom Value to combine Customers and Vouchers Data Extensions to randomly match one voucher to a customer, see Combine Data Extensions without Matching Columns.
Video overview
Create a Row Number Custom Value
- Under Custom Values, click the Add new value button.
- Provide a name for the Custom Value, select Apply formula to a field as Type, and click Next.
- Select Row Number as Type of Formula and click Next.
- Select the Data Extension, Field, and either ascending or descending Order to start the subsequent numbering, e.g., in the case below, the numbering will start from the lowest CustomerId.
- Click Save and move the new Custom Value to the Target Data Extension fields.