Alteryx tool

Hi,

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!

Doc1.docx

Expression

Accepted answers

fharper

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

MichaelSu

@aparna0208 , try this workflow instead. Add a summarize before the multi-row and then append back to the original

Dually_Registered_V2.yxmd

All comments

MichaelSu

Hi @aparna0208 ,

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.

Thanks,

Mike

Dually_Registered.yxmd

fharper

aparna0208

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!

Dually_Registered.yxmd

aparna0208

Thank you for the inputs:) @fharper

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703