community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Join and replace

Highlighted
Asteroid

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 

RoutePointHours/ Times 
388-3256-3883881,5
388-3256-38832562
371-3883714
371-3883885

 

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!

Pulsar

There must be an easier way, but this works

 

join and replace.png

Alteryx Certified Partner
Alteryx Certified Partner

Here's perhaps a more simple solution that to that offered by @DavidP, but we all do things in a different way!

 

 

Pulsar

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...

Labels