Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that set Season collections like below:
SeasonLaunch:
Season. | Date_ini | Date_end
Winter_20 | 01/03/2020 l 01/08/2020
Summer_21 | 01/09/2020 | 28/02/2021
SalesTable:
Product | Sales_Date
ProductTable:
Product
I need to classify the products based on their first sales date by adding the ‘SeasonLaunch’ column to the ‘ProductTable’ in the script.example:
Product A, 1o. sale was in 20/05/2019, them SeasonLaunch is: Winter_19
Sounds like textbook IntervalMatch. Have you tried using that?
1) Load the data
2) Find the first sales date for each product (min() with Group By)
3) Intervalmatch
obrigado. mas pode descrever como fazer isso por aqui?