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.
Please see the attachment. I have an output file with list of contacts and all related info. In attached snapshot, Scott William has two values for registration where one is Registered and other is BD. The other two contacts has one row each. I am trying to look for the contacts which has both registration values(Registered and BD) and categorize it as Dually Registered and filter out those rows. Just trying to see if this is possible using Alteryx? Thank you!
This is definitely possible with Alteryx. There are definitely multiple ways of accomplishing this, I thought it would be best to use the multi-row formula tool. Please have a look at attached solution.
depending on what you want to do an easy way would be to use the Smmarize tool. Group by the name and count then...you get person1 with 2 and the other two people with count of 1 and filter on the count and you get only those = 1 or != 1 according to your interest. you can do this many ways but in the basic way you expressed this Summarize tool is maybe easier
Thank you for the quick response @MichaelSu I tried this and it worked but there is a small problem when the rows are jumbled up. For example if one contact say Scott William has 3 rows and the first two have values as Registered and BD. It looks for the that pair and indicates it as 'Y' but when there is another row at the end then that is counted as 'N'. Please see attached workflow. Thank you!