Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find the same user with different product enabling status

k3pineapple
8 - Asteroid

Hi ,

 

I would like build a section for cross product check but within the same user. With this workflow, I may find out the user who has been enabled or not enable on certain products. 

 

I have already had a simple one, but I am not satisfied with the solution, since it may contain the duplicate result. e.g.: If there are two enabled products under one user, it will generate one extra rows for the not enabled product. I am seeking your help to create a new flow or improve my flow in order to get the perfect answer that:

Even if one user has been enabled 3 products, and has 2 not enabled products, the i only get two rows of data not 6 rows. Thank you

k3pineapple_0-1665475494897.png

 

 

Sample data

FirmProductStatusUser
AAppleEnabledAmy
AAppleEnabledBen
AAppleNot EnabledCindy
ABananaEnabledAmy
ABananaNot EnabledBen
ABananaNot EnabledCindy
ACheeryNot EnabledAmy
ACheeryNot EnabledBen
ACheeryNot EnabledCindy
BAppleEnabledDav
BAppleEnabledEas
BAppleEnabledFra
BBananaEnabledDav
BBananaEnabledEas
BBananaNot EnabledFra
BCheeryEnabledDav
BCheeryNot EnabledEas
BCheeryNot EnabledFra

 

 

Output Data:

FirmProductStatusUserRight_ProductRight_StatusRight_User
ABananaNot EnabledBenAppleEnabledBen
ACheeryNot EnabledAmyAppleEnabledAmy
ACheeryNot EnabledBenAppleEnabledBen
BBananaNot EnabledFraAppleEnabledFra
BCheeryNot EnabledEasAppleEnabledEas
BCheeryNot EnabledFraAppleEnabledFra

 

1 REPLY 1
vlad_kutateladze
9 - Comet

Hi @k3pineapple Please have a look if this works for you. 

 

Here workflow joins 'not enabled' and 'enabled' rows and after deletes extra rows based on values in 'not enabled' part. 

 

vlad_kutateladze_0-1665479843270.png

 

 

Labels
Top Solution Authors