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

Hi @fjlorenzo 

One way of doing this.

Many thanks

Shanker V

Joining Files and Identifying Duplicate Access.yxmd