Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

how to exclude common data from different users

KNiranjan
7 - Meteor

Hello All,

 

i have data having users information and profile information. Here i want to exclude the data if users have same profile information. I want to show only i if the users have different role.

 

Thanks,

NK 

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @KNiranjan 

 

Can you provide more details, sample input data and expected output.

KNiranjan
7 - Meteor

@atcodedog05  Thanks for your reply, Below is format input data and expected output 

 

Input    
Profile User1User2User3User4
Role13 1 
Role21241
Role3 12 
Role42619

 

Output

Profile User1User2User3User4
Role13 1 
Role3 12 
atcodedog05
22 - Nova
22 - Nova

Hi @KNiranjan 

 

Can you provide explanation on how you arrived at the output?

KNiranjan
7 - Meteor

@atcodedog05 I just want to exclude the data if all the users have same role full filled

atcodedog05
22 - Nova
22 - Nova

Hi @KNiranjan 

 

So basically even if one role is not filled it should be shown.

 

Workflow:

atcodedog05_0-1628870401840.png

 

Hope this helps : )

 

KNiranjan
7 - Meteor

@atcodedog05 Thank you 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @KNiranjan 

Cheers and have a nice day!

Labels