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.
My first thought was to approach this in a similar way to how LordNeilLord did, but then I thought of another way that also works while demonstrating how some of the other Alteryx tools work. Simpler is always good, particularly if it is efficient which LordNeilLord's method is, but having other ways to achieve a problem can help in other circumstances.
I hope this helps, but in any case you now have two ways to solve the problem!