How to merge multiple lookup field values into single field value

[lksridhar]

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.

[kamlesh_vaghela]

@lksridhar 

Try something like,

|inputlookup first_lookup.csv | append [|inputlookup second_lookup.csv ]| stats values(*) as * by user

KV