Re: [Tutor] csv merge with different column title

2018-04-14 Thread Peter Otten
Pareshkumar Panchal wrote: > I am trying to merge two csv files with following condition. > > filea.csv column( a1,a2,a3) > fileb.csv column( b1,b2,b3) > > i wanted to merge if a1 & b1 reference (as the title is different but > contents are valid for comparison). If the column title is the

Re: [Tutor] csv merge with different column title

2018-04-14 Thread Alan Gauld via Tutor
On 14/04/18 04:32, Pareshkumar Panchal wrote: > I am trying to merge two csv files with following condition. > > filea.csv column( a1,a2,a3) > fileb.csv column( b1,b2,b3) > > i wanted to merge if a1 & b1 reference (as the title is different but > contents are valid for comparison). also the

[Tutor] csv merge with different column title

2018-04-14 Thread Pareshkumar Panchal
Hi, I am trying to merge two csv files with following condition. filea.csv column( a1,a2,a3) fileb.csv column( b1,b2,b3) i wanted to merge if a1 & b1 reference (as the title is different but contents are valid for comparison). also the result i need is a1,a2,a3,b1,b2 (not b3). i am using