I have table_1 (excel) with fields:
I have table_2 (excel) with fields:
I want to create table_3 out of those two with fields:
Calc = Sum / Total
and drop the tables and keep with table 3.
How do i do it?
load YearMonth, Sum, Total, Sum/Total as Calc
drop table table_1;
i did as you said.
i got results like this from example:
YearMonth Sum Total Sum/Total
it's not joined in one line....
i changed the concat to left join it worked. thank you.
Retrieving data ...