Mutlirow formula / Batch Macro

[Shank]

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?

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

[Qiu]

@Shank 
Better you can post this on Design forum. :)

I believe for sure Multi-row tool can do this, but I tried with a Unique tool.

[Shank]

@Qiu 

Thanks for the work Around, Sure going forward will post these kind of messages in different forum.

With the workaround which you have provided will not get the intended result. 

for example if part 2 should flow from 1842 to 1849 then 2022, but with the workaround which you have provided will not provide that link. this something like transport link first you have to go from location A to B then C.

is there any other workaround to achieve this?

[Qiu]

@Shank 
Thanks for the feedback and now I realized it is not that simple...
Can you check the accepted solutions if help. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connect-the-travel-path-in-succession/...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Travel-itinerary-sequence/td-p/320541/...