Question: Is ROW_NUMBER() supported in DESelect?
Answer: Absolutely, through the use of Row Number custom value. This allows a user to create sequential numbers (eg. 1,2,3..) on each row of a Data Extension. The use of ASC and DESC is also supported on this custom value.
Example: Creating sequential numbers to each row of Data Extensions to be used as a matching column.
- August '21 Release Notes
- Can I combine Data Extensions that do not have any matching columns?