Is ROW_NUMBER() supported in DESelect?

Zandra Marquez

October 03, 2022 09:22
Updated

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?

Related articles