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
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.
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.
thank you.
a1 field is in both file ? In every line ?