Hi Richgalloway,
Thanks for spending time on this. Please find the details below.
file1.csv
"OU","unique","accountname","Accountinformation"
"sitsai,ou=users,dc=company,dc=com","alpha","sphere","NA"
for Accountinformation field we have A and NA values which mean Active and Not Active.
file2.csv
"OU","unique","ID","Status","AID",
"sitsai,ou=users,dc=company,dc=com","alpha","12563","T","app1",
for status we have T and A values.
file3.csv
"ApplicantionID", "employee","estatus"
"12563","apha","1"
For estatus we have 0 and 16 values. 0 mean active and 1 mean not active.
In file1 and file2 we have unique value alpha with field unique,
In file2 and file3 we have unique value 12563 with field names AID and ApplicationID.
We need to join the csv files and display fields unique, Accountinformation, Status, estatus in a table
when Accountinformation is A, status is T and estatus is 0.
Thanks.
... View more