Joining Files and Identifying Duplicate Access

[fjlorenzo]

Hi, need help on the following. Thank you for your help.

1. I need to add the HR information to file1 from file2
2. I also need to output and validate all users with two roles but with different access

Input File1
Name	Roles	Access
Alex	birthright role1	Read
Alex	business role1	Write
Allen	birthright role2	Read
Allen	business role3	Read
Romy	birthright role1	Read

Input File2
Name	Job Role
Alex	Analyst
Allen	Data Encoder
Romy	Programmer

First Output - Need to add Job Role
Name	Roles	Access	Job Role
Alex	birthright role1	Read	Analyst
Alex	business role1	Write	Analyst
Allen	birthright role2	Read	Data Encoder
Allen	business role3	Read	Data Encoder
Romy	birthright role1	Read	Programmer

Second Output - will display only user with two roles but with different access
Name	Roles	Access	Job Role
Alex	birthright role1	Read	Analyst
Alex	business role1	Write	Analyst

[ShankerV · Accepted solution]

Hi @fjlorenzo 

One way of doing this.

Many thanks

Shanker V

[fjlorenzo]

Thank you Shanker. Can you post the workflow?

[ShankerV]

Hi @fjlorenzo 

The workflow is saved and you can see at the end of the post with download symbol.

Please let me know if you face any issues in downloading the workflow.

[fjlorenzo]

Hi Shanker, thank you for your help.

[fjlorenzo]

Shanker, I tried it but it's still not displaying users with different access.

[ShankerV]

Hi @fjlorenzo 

I believe you might have used this in the huge dataset.

Can you please few samples how the huge dataset is.

So that can tweak the workflow for your huge dataset.

Many thanks

Shanker V

[fjlorenzo]

@ShankerV  it is working now. I grouped it by Identity. Thank you.