Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
i changed the concat to left join it worked. thank you.
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;
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!!
i changed the concat to left join it worked. thank you.