Hi Folks,
I have two lookup files which contain the user information such as username, email and company.
for example:
1. First lookup file.
user email company
siva siva11@gmail.com google
arun arun11@gmail.com
2. Second lookup file.
user email company
arun arun11@gmail.com yahoo
how to merge the two lookup files and merge the value.
the expected output should be like this.
user email company
siva siva11@gmail.com google
arun arun11@gmail.com yahoo
Could you please anyone suggest to get the expected results.
Try something like,
|inputlookup first_lookup.csv | append [|inputlookup second_lookup.csv ]| stats values(*) as * by user
KV