I have a main table with fields (from SQL):
now i load a table a (from excel) with fields
How do I bring Cost_Price_Per_Month value (from the excel table) to the Cost_Price on first table to make a calculation on it.
In the script level.
inner join (table_1)
load YearMonth, Cost_Price_Per_Month
load ID, YearMonth, Date, Sell_Price, if(isnull(Cost_Price), Cost_Price_Per_Month, Cost_Price) as new_cost_price
drop column Cost_Price, Cost_Price_Per_Month from table_2;