topic Re: Joining two tables without common field or key. All rows of 1st table must join with all the rows of the second one in Splunk Search

Joining two tables without common field or key. All rows of 1st table must join with all the rows of the second one

nkankur — Tue, 20 Mar 2018 08:28:02 GMT

I have data as given below in table format
A B C D E F
517 2498 186 1000 250 100
399 314 1559 100 100 1000

I want each row of D E and F against each row of A B and C kind of cross transformation
output should look like this:
A B C D E F
517 2498 186 1000 250 100
517 2498 186 100 100 1000
399 314 1559 1000 250 100
399 314 1559 100 100 1000

Thanks in advance!

Re: Joining two tables without common field or key. All rows of 1st table must join with all the rows of the second one

p_gurav — Tue, 20 Mar 2018 11:06:53 GMT

Can you try something like :

    index="your_index" | table A B C | join type=left max=0 [search index="your_index" | table D E F]

Re: Joining two tables without common field or key. All rows of 1st table must join with all the rows of the second one

logloganathan — Tue, 20 Mar 2018 12:42:22 GMT

Please refer this document

https://docs.splunk.com/Documentation/Splunk/7.0.2/SearchReference/Eval

by using this command, you can use logic for cross transformation