This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
You were on the right track. Check out the example workflow attached. I added a multi-row formula tool to get 1-100 repeated over and over again Column2. Then sort Cloumn2, rename it Column1 add a RecordID and join back to the original.
Thank you Laura! This is great, exactly what I was looking for. Because it has been just two weeks at the school, I'm struggling to understand fully what the first formula is doing. Would you mind explaining me? thank you a lot
No problem! The Multi-Row Formula tool is great because it allows you to look up and down at other values within a column to calculate the result.
IF [Row-1:Column2]=100 THEN 1 ELSE [Row-1:Column2]+1 ENDIF
In plain English means if the value of the row above is 100 then start the count over again at 1 otherwise take the value in the row above and add 1. Since there is no 'row above' the first row, (row above + 1) equals 1.