I need to left join these 2 tables so that the columns from the budget table joins to the first one when event_code and weeks_left_to_event are the same. I came up with this code but doesn´t work.
Many thanks!!!
This is the code:
LIB CONNECT TO 'Amazon_Redshift_redshift-dwh.cwafb1bxivm3.eu-west-1.redshift.amazonaws.com';
budgets:
LOAD
"Código del evento" as event_code,
event_end_time as budget_event_end_time,
timestamp(FECHA) AS budget_date,
"NUMERO DE TICKETS" as budget_quantity,
PRECIO as budget_price,
"BOOKING FEE" as budget_fee,
"GROSS REVENUE" as budget_gross_revenue,
round(num(Interval(event_end_time - timestamp(FECHA), 'DD'))/7,2) AS weeks_left_to_event
FROM [lib://DataFiles/Ticketing 2024.xlsx]
(ooxml, embedded labels, table is [Hoja 3]);
left join
ON
budgets."Código del evento" = [marts_event_ticketing]."event_code"
