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.
@linwqg, try the following search
| inputlookup csv1.csv where
[| inputlookup csv2.csv
| rename numberY as numberX
| table numberX]
@linwqg, try the following search
| inputlookup csv1.csv where
[| inputlookup csv2.csv
| rename numberY as numberX
| table numberX]
Thanks niketnilay. Will give it a try too.
Your approach work as well. Thanks niketnilay.
@linwqg, please accept the answer if your issue is resolved to mark this question as answered 🙂
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
Many thanks. Will definitely give this a try as well.
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
|search [search |inputlookup csv2|rename numberY AS numberX |table numberX]
↓
search (numberX="X" OR numberX="Y" OR numberX="Z")
What's the different between 1 and 2?
Hi,
try something like this:
|inputlookup csv2|lookup csv1 numberX AS numberY OUTPUTNEW info,more_info|table numberX, info, more_info
Thanks for the headstart.
Tried but it does not seem to work.
I did abit of cleanup and i think it works. Thanks p_gurav.