Match values under 2 different fields

[linwqg]

Need help. Appreciate in advance.

I have 2 lookup csv. I need to match each value under "numberX" field against the list of values under "numnberY" field. If there is a match, e.g. 4653, to obtain the following output.

[niketn · Accepted solution]

@linwqg, try the following search

| inputlookup csv1.csv where 
    [| inputlookup csv2.csv 
    | rename numberY as numberX 
    | table numberX]

[linwqg]

Thanks niketnilay. Will give it a try too.

[linwqg]

Your approach work as well. Thanks niketnilay.

[niketn]

@linwqg, please accept the answer if your issue is resolved to mark this question as answered 🙂

[HiroshiSatoh]

Try this!

|inputlookup csv1|search [search |inputlookup csv2|rename numberY AS numberX |table numberX ]
|table numberX, info, more_info
OR
|inputlookup csv1|join type=inner numberX AS numberY [search |inputlookup csv2]
|table numberX, info, more_info

[linwqg]

Many thanks. Will definitely give this a try as well.

[linwqg]

I understand from the first pipe onward, that we are renaming the field and table it out.

Why is this important? How to interpret the search before all these?

search |inputlookup csv2|rename numberY AS numberX |table numberX

[HiroshiSatoh]

|search [search |inputlookup csv2|rename numberY AS numberX |table numberX]
↓
search (numberX="X" OR numberX="Y" OR numberX="Z")

[linwqg]

What's the different between 1 and 2?

1. |inputlookup csv1|search [search |inputlookup csv2|rename numberY AS numberX |table numberX ]
2. |inputlookup csv1|search [|inputlookup csv2|rename numberY AS numberX |table numberX ]

[p_gurav]

Hi,

try something like this:

|inputlookup csv2|lookup csv1 numberX AS numberY OUTPUTNEW info,more_info|table numberX, info, more_info

[linwqg]

Thanks for the headstart.

Tried but it does not seem to work.

[linwqg]

I did abit of cleanup and i think it works. Thanks p_gurav.