Hi,
I Need to find the TRIP for multiple travels happened between dates.
Attached is the sample data and I need to auto generate TRIP ID for the entries.
Hi @Harish_G,
you can create this expected output with a single Summarize Tool.
Please see attached workflow as reference.
Your unique identificator is the ReportID, EmployerID and Itinerary Key. So this is going to be your "Group By"
The Dataset should be sorted by these columns and the StartDate before starting with the Summarize Tool.
Now you can use the Min/Max functions for your trip dates and the First/Last for the countries to show in your report. To get the right First/Last results it's required to be sorted.
Best regards,
David
I am not able to see any rule based on the dataset you provided to generate the TRIPID.
I have no idea why row 7 should have the same ID like row 8.
And the way around why row 10 has not the same ID like row 11.
You need to give us some more insights how to interpret this dataset.
Maybe describe your thinking process how the TRIPID is manually generated.
HI @DavidSta ,
sorry for the confusion. I revised the data and attached the sample.
I have input and expected output in the attached format.
I'm looking to find the start and end time for a trip and Departure and Arrival country.
Regards,
Harish
