Dear all, I need your help with comparing two arrays.
I have two lists:
File1.csv:
“Group”,“Name”,“SamAccountName”,“distinguishedName”
“Vpn Users”,“XXXXXX”,“XXXXXX”,“CN=XXXXXX,OU=example,DC=mydomain,DC=world,DC=com”
“Vpn Users”,“YYYYYY”,“YYYYYY”,“CN=YYYYYY,OU=example,DC=mydomain,DC=world,DC=com”
“Vpn Users”,“ZZZZZZ”,“ZZZZZZ”,“CN=ZZZZZZ,OU=example,DC=mydomain,DC=world,DC=com”
File2.csv:
“Name”,“Surname”,“Login”,“Type”
“Name1”,“Surname1”,“XXXXXX”,“Employee”
“Name2”,“Surname2”,“YYYYYY”,“Consultant”
I need to match all entry in File1 with all entry in File2 and generate output like
User XXXXXX is Employee
User YYYYYY is Consultant
User ZZZZZZ is not present
Could someone please help me kindly?
It would help me a lot.
Thanks in advance.
Andrea.
Ciao