Hello everyone!
My 50/50 split wasn't very 50% after all (see attached),
From 28 total records, 19 went to A and only 9 to B.
I appreciate that my audience is very small but can someone explain why this happened and if I can do anything to achieve a more even split?
3 respostas
Hi, @Nick Topalidis
Please try the following SQL.
SELECT
Id,
CASE
WHEN ROW_NUMBER() OVER(ORDER BY NEWID()) % 2 = 0 THEN 'A'
ELSE 'B'
END AS AB_Flag
FROM
YOUR_DE_NAME
