Forum Discussion
Sujit_Thakur
Solution Sage
Solution SageMerging two rows
Dear all , I have a data table . In which I have fields like Name , City , Start date , start time , end date , end time and some measures to calculate their percentage of travelling according to...
Sujit_ThakurSolution Sage
Solution SageDear amitchandak sir ,
Following is my dummy raw data
Table 1 - Raw Data Table
| Name | City | Start Date | Start Time | End Date | End time | Distance(KM) |
| Sujit | Pune | 11-09-20 | 2:00 AM | 11-09-20 | 2:04 AM | 0.2 |
| Sujit | Pune | 11-09-20 | 2:10 AM | 11-09-20 | 2:15 AM | 0.3 |
| Sujit | Pune | 11-09-20 | 02:30 | 11-09-20 | 03:00 | 4 |
Table 2 : Allocated Distance
| name | Date | allocated_Distance |
| Sujit | 11-09-20 | 45 |
Now when now i am using raw data table into table visual ,
it is showing as it is shown above in table 1 ,
but what i want is while showing in table visual , it must merge two rows which are recorded within 20 mins of time stamp
desired output
| Name | City | Start Date | Start Time | End Date | End time | Distance |
| Sujit | Pune | 11-09-20 | 2:00 AM | 11-09-20 | 2:15 AM | 0.5 |
| Sujit | Pune | 11-09-20 | 02:30 | 11-09-20 | 03:00 | 4 |
Sujit_ThakurSolution Sage
Solution Sageamitchandak sir ,
Do you suggest making a new table in model , using Calculate table ???
Please help,