Joining Tables to new table + calculation

[#1]

Hi.

I have table_1 (excel) with fields:

YearMonth

Sum

I have table_2 (excel) with fields:

YearMonth

Total

I want to create table_3 out of those two with fields:

YearMonth

Sum

Total

Calc = Sum / Total

and drop the tables and keep with table 3.

How do i do it?

Thank You.

[#2]

table_1:

load

YearMonth,

sum

from Excel.sheet1;

concatentat(table_1)

load

YearMonth,

Total

from Excel.sheet2;

table_3:

load YearMonth, Sum, Total, Sum/Total as Calc

resident table_1;

drop table table_1;

[#3]

i did as you said.

i got results like this from example:

YearMonth      Sum     Total          Sum/Total

20131               100

20131                           50

it's not joined in one line....

help!!

[#4 · Accepted solution]

i changed the concat to left join it worked. thank you.