We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.
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
20 - Arcturus

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
20 - Arcturus

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
20 - Arcturus

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
20 - Arcturus

Happy to help : ) @KNiranjan 

Cheers and have a nice day!

Labels