Hi guys, I have a database of online orders, i need to flag id_clients that have the same product ordered in less than 2 days a part. Input: Client_IDProductOrder_date1 apple29/04/20241banana25/04/20241apple27/04/2024 Expected output: Client_IDProductOrder_dateFlag1 apple29/04/20241 1banana25/04/202401apple27/04/20240 How can i make this flag column?

How to compare dates

Hi guys,

I have a database of online orders, i need to flag id_clients that have the same product ordered in less than 2 days a part.

Input:

Client_ID	Product	Order_date
1	apple	29/04/2024
1	banana	25/04/2024
1	apple	27/04/2024

Expected output:

Client_ID	Product	Order_date	Flag
1	apple	29/04/2024	1
1	banana	25/04/2024	0
1	apple	27/04/2024	0

How can i make this flag column?

Datasets

Date Time

Best Practices

Transformation

Accepted answers

adamweaver39

Hey @VitorCM ! I think you could use the DateTimeDiff formula to calculate date differences, grouped by product, and flag when it meets you're criteria through a second formula tool (i.e. difference <= 2 is "Flag") -- just make sure your date field reads as a date before running the calculation!

All comments

adamweaver39

binu_acs

@VitorCM One way of doing this

DayDiff_29042024.yxmd

VitorCM

Amazing, works! Thanks for the solution!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703