Jul-30-2019, 02:38 AM
Hi,
I have two csv files.
Csv 1
A 1
B 2
C 3
Csv 2
A 10
B 20
C 30
How do i find the sum difference of column 2
Like 10-1+20-2+30-3
So output csv would be
A 9
B 18
C 27
Total 54
I can achieve the difference but not total. Any help?
I have two csv files.
Csv 1
A 1
B 2
C 3
Csv 2
A 10
B 20
C 30
How do i find the sum difference of column 2
Like 10-1+20-2+30-3
So output csv would be
A 9
B 18
C 27
Total 54
I can achieve the difference but not total. Any help?