how to exclude common data from different users

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,

Topic of Interest

Accepted answers

atcodedog05

Hi @KNiranjan

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

Workflow:

Hope this helps : )

users.yxmd

All comments

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?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335