I have two tables
The first table has a list of Categories.
The Second table has a list of Offices.
Such as
Category
Power
Voice
WAN1
WAN2
LAN
Offices:
Office1
Office2
Office3
Office4
I would like to join these 2 csv lookup files such that I get the following as a result:
Power Office1
Power Office2
Power Office3
Power Office4
Voice Office1
Voice Office2
Voice Office3
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]
I have found my answer, using max=0 worked great!
http://answers.splunk.com/answers/52656/is-cartesian-product-not-possible-in-splunk-using-join
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.
I have found my answer, using max=0 worked great!
http://answers.splunk.com/answers/52656/is-cartesian-product-not-possible-in-splunk-using-join