Hi ,
I have 500000 variables. I need to create a string cloumn with 20 % of 500000 population as 'first time freshman', 60 % of 500000 population as 'first time transfer' and remaining 20 % as 'third year'
can some one please help me in doing that in alteryx. I thank you in advance.
-Bharath
Solved! Go to Solution.
actually I have 500000 counts sorry not variables. I mentioned it wrongly in my previous post.
-Bharath
Do you already have an indicator for which rows should be marked as First-Time Freshman, First-Time Transfer, and Third Year? If so, use the Formula tool to create a string field.
If you are looking to randomly assign a percentage of your data to a category, you should look at both Create Sample and Sample tool.
Hi Michael,
Thank you for your reply.No I dont have indicator for which rows should be marked as First-Time Freshman, First-Time Transfer, and Third Year. I found a way of doing it but the issue is that I have 500000 students. so I if I assign 20% of sample at random to "first time freshman" then those students should not be included for assigning 60% for "First time Transfer " .
please let me know a way solve it.
-Bharath
Hi Michael,
Thank you for Helping me.
-Bharath