Generate rows (again)

Hamder83

Hi 

I have a small dataset:

Shipment_awb (ordre number)
This has a scan date (blslScanDate)

The customer has 3 pickup days:
Monday,Wednsday and Friday

And the pickup date is the lateste date compared to the blslScanDate -1.

So lets say:
Shipment_awb = 5988278015
Has blslScanDate 14-09-2021 So the pickup date is 13-09-2021.

Shipment_awb = 520000019641907012618201
Has blslScanDate 15-09-2021 So the pickup date is 13-09-2021.

I have 821 sample shipment_awbs and I wanna find the 1 correct ActualPickupDate for each shipmen_awb.


Any help would be appriciated 

sample1.yxzp

atcodedog05

Hi @Hamder83 

Here is how you can do it.

Workflow:

Question 15-09-2021 is Wednesday why are you not taking same why are you taking 13.-09-2021 for 2nd scenario.

Hope this helps : )

Dates.yxmd