I would like to join two partitioned datasets (both date partitioned), by creating week number (not created in flow)
Dataset1 is partitioned on execution dates(weekly once) of year 2019.
Dataset2 is partitioned on execution dates(weekly once) of year 2018.
I want to join these two datasets by week number of year (not present in the flow).
In join recipe I thought of creating week number of execution date/partitioned date (thru "pre-join computed columns" section), but not succeeded.
Could you help me out.