Dear All,
I am facing some challenge to concatenate rows based on the column id can some one help on how can we achieve this?
below is the scenario.
Example: I have a part 1 which goes from line 2022 - 2060 and from 2060 - 1692 (But i have this information in two different columns). I need an output to show line information in one row like 2022-2060-1692 for part 1. can anyone help us on this?
General example to understand the concept:- in order to reach location C from location A. I have to travel location A to B first then from B to C
A-B-C
Input:
Part | Line from | Line To |
1 | 2022 | 2060 |
1 | 2060 | 1692 |
2 | 1849 | 2022 |
2 | 1842 | 1849 |
3 | 1692 | 1699 |
3 | 1699 | 2022 |
3 | 2022 | 2025 |
Expected Output:
Part | Line Info |
1 | 2022-2060-1692 |
2 | 1842-1849-2022 |
3 | 1692-1699-2022-2025 |
Best Regards,
Shashank
There is no link which is available to connect from 2022 to anywhere else that is the reason end destination is 2022. In above example if we had a continuity like from 2022 to 2099. then our end goal will be 2099.
Yes you are right the end goal is always in the right cell of the last part of the journey.