Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
Thank you for reading this. I'm working on a consolidation project where I am trying to find the best way to isolate the customers that have orders shipping on consecutive days. For example Customer A has orders that shipped today, tomorrow, Wed, Thurs, Monday, Tues, Wed.
Any help would be greatly appreciated.
attach sample data,ShipCustomer will brings repeated shipping customers on consecutive dates
load
Customer,ShippiingDate,
if(peek(Customer)=Customer and Shippingflag='Y' ,Customer )as CustomerDa,
if(peek(Customer)=Customer and Shippingflag='Y' and peek(ShippiingDate) =date(ShippiingDate-1), Customer )as ShipCustomer;
LOAD
Customer,
Shippingflag,
ShippiingDate
FROM [lib://com/Shipping.xlsx]
(ooxml, embedded labels, table is Sheet1);
Thank you Channa, what exactly does the shipping flag represent with Y and N?