Hello everyone!
I have the following problem:
The target is to match two tables. In the output the second every point in route must be replaced by Hours/ Times. Every point has unique Hours/ Times only within the route (so the same point can have different Hours/ Times in different routes)
Table 1
Route | Point | Hours/ Times |
388-3256-388 | 388 | 1,5 |
388-3256-388 | 3256 | 2 |
371-388 | 371 | 4 |
371-388 | 388 | 5 |
Table 2
Route |
388-3256-388 |
371-388 |
Output
Route_h/t |
1,5-2-1,5 |
4-5 |
Thank you very so much for any help!
Solved! Go to Solution.
Here's perhaps a more simple solution that to that offered by @DavidP, but we all do things in a different way!
Great solution @BenMoss. Using Concat in the Summarize tool is very neat and definitely something I'll be using all the time now! How did I not know that? This opens up so many doors...