join lookup based on the field

[Muthu_Vinith]

Hi, 
I'm trying to join two lookups based on the name field. Here's what i have,

|inputlookup abc.csv
|table name published
|lookup def.csv name as name OUTPUT releaseyear

When i run this, i get a multiple values in the field. How to get rid of these multiple values and ensure only one value per field?

Thanks!

[Muthu_Vinith]

Thanks @yuanliu @ITWhisperer . It works

[yuanliu]

Alternatively, you can do

|inputlookup abc.csv
|table name published
|lookup def.csv name as name OUTPUT releaseyear
| eval releaseyear = mvdedup(releaseyear)

[ITWhisperer]

Assuming it is releaseyear that has the multiple values, you could try mvexpand

|inputlookup abc.csv
|table name published
|lookup def.csv name as name OUTPUT releaseyear
|mvexpand releaseyear