how to exclude common data from different users

[KNiranjan]

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 

[atcodedog05]

Hi @KNiranjan 

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

[KNiranjan]

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

Input
Profile	User1	User2	User3	User4
Role1	3		1
Role2	1	2	4	1
Role3		1	2
Role4	2	6	1	9

Output

Profile	User1	User2	User3	User4
Role1	3		1
Role3		1	2

[atcodedog05]

Hi @KNiranjan 

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

[KNiranjan]

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

[atcodedog05 · Accepted solution]

Hi @KNiranjan 

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

Workflow:

Hope this helps : )

[KNiranjan]

@atcodedog05 Thank you 

[atcodedog05]

Happy to help : ) @KNiranjan 

Cheers and have a nice day!