There is a DE called TestDE with EMAIL_ADDR , CUST_SEG, FREQ_SEG attributes. where CUST_SEG has values x and y whereas FREQ_SEG has values a,b,c and d. Select 10% of audience from TestDE in such a way that CUST_SEG has equal distribution
of x and y values whereas FREQ_SEG has equal distribution of a,b,c and d values. Kindly do help on the same.
답변 1개
I would suggest looking into SQL functions Row_Number(), NTILE() in conjunction with Partition BY and OVER functions. These functions should allow you to achieve your desired results.
I personally utilize partition by very frequently for pulling test audiences from live data that capture all field variations used in dynamic sends. HTH
