Jun-15-2019, 08:58 PM
(Jun-06-2019, 08:52 PM)Ecniv Wrote: Hi
I cannot use merged as you require a unique field. I do not have one.
I am trying to get the check out for each check in to produce a trip/journey, duration, cost etc...
But I need the check out that is immediately after the checkin (assuming I have checked in and out properly). There is a small chance I checked in and forgot to check out... Unlikely but possible.
Any ideas on why its not bringing back at least one record when filtered on date and time ?
I'm still not really understanding what you're looking to accomplish and your codes are very confusing. One question I have is how do you not have a unique column to merge on? I would think that if you are checking in/checking out of a hotel that would mean you have a corresponding transaction number or something similar that could be used to properly identify the trip. Even a separate column that includes a reference to the specific trip like "SpainVacation" would work. That is unless I'm completely wrong in my understanding of what trying to accomplish.
Like I said before it would be much easier for me to help you if I could see the contents of the file you're working with - or at least a file with a similar structure.