/sfmc-sql-split-random-25-percent.sql
Created Jul 31, 2017
| select top 25 percent | |
| de1.* | |
| from [dataextension1] de1 | |
| left join [dataextensionsplit_1] split1 on (de1.[email address] = split1.[email address]) | |
| where split1.[email address] is null | |
| order by newid() | |
| /* writes to dataextensionsplit_2 */ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment