I have two csv files : say a.csv, b.csv
a.csv looks like this :
property1,property2,100
property3,property4,200
In a.csv, the combination of column1 and column2 will be unique
b.csv looks like this
property1,property2, 300, t1
property1,property2, 400,t2
property3, property4,800,t1
property3, property4,12200,t2
And I want the output to be :
A new column added which is the third column from a.csv matching first two columns of a.csv and b.csv
property1,property2, 300, t1,100
property1,property2, 400,t2,100
property3, property4,800,t1,200
property3, property4,12200,t2,200
I am not sure how we can achieve this.
Please help.
Thanks