Splunk Search

how to merge data from different two source ?

New Member

my data is csv file

My data below

source = A1
field name = a1, b1, c1,...

soruce = A2
field : a1, b2, c2,...
field : a1, b3, c3,..
field : a1, b4, c4,..
.
.
.

.

I wand to make a table

a1, b1, c1, b2, c2
a1, b1, c1, b3, c3
a1, b1, c1, b4, c4

Tags (3)
0 Karma
1 Solution

Communicator

Hi sangjoonlee,

If a1 is present in both sources then you can use join:

<source 1 search> | join a1 [search <source 2 search> | table a1, b1, c1, b2, c2]

Hope this helps.

View solution in original post

Communicator

Hi sangjoonlee,

If a1 is present in both sources then you can use join:

<source 1 search> | join a1 [search <source 2 search> | table a1, b1, c1, b2, c2]

Hope this helps.

View solution in original post

New Member

thank you.

0 Karma

Communicator

a1 field is in both file ? In every line ?

0 Karma