Need help in identifying what customers have orders shipping daily

[Nellie115]

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. 

[Channa]

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);

[Nellie115]

Thank you Channa, what exactly does the shipping flag represent with Y and N?