Hi All,
I have 2 table. 1 table is my warehouses daily available slot to receive goods. Another table is the goods ETA at port. We already preplanned which goods is to which warehouse. But I need a query to match the time slot table to goods ETA table. whichever ETA reached first will take earliest slot based on warehouse, but some of the earliest slot available is earlier than ETA. Any suggestion? Thanks.
See if the attached PQ solution works for you. I didn't make it pretty or very advanced. And it requires quite a bit of merging, duplicating, sorting and filling along the way. Finally append the ETA table with a table that hold available slots based in the rule that he slot times should be on or after ETA.
crossposted: https://forums.excelguru.ca/threads/date-slot-allocation-based-on-slot-available-and-eta-date.11677/#post-48422
Please read--> https://excelguru.ca/a-message-to-forum-cross-posters/
Hi Riny,
Thanks for your PQ. But there is some issue, i.e transaction 1003 and 1004 should able to fit in the time slot.
Ah, I see. Other than a small filter error my method doesn't seem to work. don't really have a solution for that at the moment. Perhaps later,
