Row Number Custom Value

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 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 scenario 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 https //support deselect com/hc/en us/articles/4405565589777 can i combine data extensions that do not have any matching columns to achieve this you can also create reusable custom values follow this link to learn https //support deselect com/hc/en us/search/click?data=bah7djohawrskwgrqi9%2fjgo6d2fjy291bnrfawrpa8uyktojdhlwzukidgfydgljbgugogzfvdoidxjsssjxahr0chm6ly9zdxbwb3j0lmrlc2vszwn0lmnvbs9oyy9lbi11cy9hcnrpy2xlcy8xmte2mdq1odg2nte2os1dyw4tss1yzxvzzs1tes1ddxn0b20tvmfsdwvzlwlulwfues1tzwxly3rpb24tbjsivdooc2vhcmnox2lkssipzjhlmdrhzwityjk3ns00zjm1lwfiytgtytm5mtk4ngfkmdnhbjsirjojcmfua2kgogtsb2nhbgvjigplbi11cwy7cfq6cnf1zxj5ssiry3vzdg9tihzhbhvlbjsivdoscmvzdwx0c19jb3vudglb 8d89b0696ecc8e9fbc9296d7434db1983a4f6f07