how to merge data from different two source ?

[sangjoonlee]

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

[hhGA · Accepted solution]

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.

[sangjoonlee]

thank you.

[3no]

a1 field is in both file ? In every line ?