Get the earliest sale date

[business_intelligence]

I am trying to get the first sale_date that is greater than the signed_up_at date.

I want this stored as a separate table where each customer_ID exists once with the first sale_date. I then want to be able to link on customer_ID to get the rest of the sale dates for a customer.

customer_ID	signed_up_at	sale_date
123	30/11/2022	01/12/2022
123	30/11/2022	05/12/2022
123	30/11/2022	12/12/2022
124	01/12/2022	06/12/2022
124	01/12/2022	08/12/2022

[MendyS · Accepted solution]

HI @business_intelligence 

Try This - 

Temp:
NoConcatenate
Load customer_ID, Min(sale_date) as sale_dateTemp
Resident Some_Table where sale_date> signed_up_at
Group by customer_ID;

[business_intelligence]

@MendyS  that worked! thank you 🙂