Merging (Sum) two simillar tables..

Hi,

I have 2 exact simillar tables. I need to prepare SUM table from them.

I tried joiner, but Its just appending columns!

** There are100+ columns to sumup. (A,B, C......)

Table1:

col1 A B C
X1 1 2 3
X2 2 3 4
X3 5 10 15

Table2:

col1 A B C
X1 3 4 5
X2 6 7 8
X3 2 4 5

 

Expected:

col1 A B C
X1 4 6 8
X2 8 10 12
X3 7 14 20

 

PS: Posting second time as first is not published yet !

 

Solved ! Using concatenate and groupby..

marked as solved.