How to tell if two rows from different tables each are both an equal match?

[minkyuk]

Hello Splunkitans,

If I am given a table of 5000 rows and a second "filter" table of 500 rows,
If I were to extract the matching 500 rows from the first table, how could I implement this ?

Since they both use [ |inputlookup all.csv ] and [|inputlookup filt.csv], could I somehow incorporate the where command?

I would appreciate any of your input!

Jack

[richgalloway · Accepted solution]

This may do it:

| set intersect [| inputlookup_all.csv] [| inputlookup_filt.csv] | ...