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:
join
<source 1 search> | join a1 [search <source 2 search> | table a1, b1, c1, b2, c2]
Hope this helps.
View solution in original post
thank you.
a1 field is in both file ? In every line ?
