Hello,
My index is called "index=main_ruolo", the fields in it are: user_id, Function, Role
The lookup table with which I need to make a merge is called "merge.csv", the fields are: Function_L, Role_L
In the lookup table "merge.csv", the Function_L - Role_L is the correct one
The purpose is to create a list of all user_id in "index=main_ruolo" where Function and Role do not match Function_L and Role_L
Ex wrong:
Function User Role
foo AFC RoleSTLC
Andrew STLC RoleAFC
Ex correct:
User Function Role Error
Fox AFC RoleSTLC X
Andrew STLC RoleAFC X
The proper Function-Role association is defined within the lookup table
Thank's for help
... View more