SQL Dataflow - Left join reduces number of rows in left table
Hi, I am trying to join 2 tables based on a "date - product" —> columns "year_month_key" and "year_month_lagged_key" My 2 tables are the following transform_data_lagged transform_data_current when i join both table via the following left join statement, i loose the first rows in the left table, "transform_data_lagged",…
