topic Adding Product Season column in a table in the script in App Development

Adding Product Season column in a table in the script

Rodlibar — Thu, 28 Sep 2023 09:57:41 GMT

I have a table that set Season collections like below:

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

Or — Thu, 28 Sep 2023 12:48:35 GMT

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

Rodlibar — Fri, 13 Oct 2023 10:44:36 GMT

obrigado. mas pode descrever como fazer isso por aqui?