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!
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]
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
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]