I have two tables
The first table has a list of Categories.
The Second table has a list of Offices.
I would like to join these 2 csv lookup files such that I get the following as a result:
Voice Office4 etc..
I attempt to join them together and the option of inner, outer, and left all produce the same results. I cannot get it to be a many to many relationship.
I have something like this:
|inputlookup Categories.csv | join [|inputlookup Offices.csv]
Here's how to do a full cross join in splunk... However, be careful what you wish for...
your first search or file ... | eval CrossJoinMe = 1 | join max=0 CrossJoinMe [your second search or file | eval CrossJoinMe = 1 ]
That code will join every result from the first search or file to each result in the second search or file, subject to all the usual limits (ie, the limit of the number of results form a subsearch, the limits of available memory, etc.)
Note - The field name
CrossJoinMe is unimportant. - It's just a field that has the same value for every event on either file.