Challenge #203: Everyone loves a toll booth

[carlosteixeira]

Here's my solution.

Spoiler

Best regards

[Kenda]

Spoiler

 

[bnjmnsmith]

Mine doesn't tie out either. It's also not as efficient as I feel like it could be. Going to check out others solutions after posting this:

Spoiler

I'm using the append tool to create a cartesian product, then filtering out the unneeded pairs and joining it. DEFINITELY not the most efficient way of doing it, but I'm excited to learn from everyone elses solutions!

[SoumyadeepSain]

Here is my solution.

Spoiler

[JennyMartin]

Spoiler

Had the same issues as everyone else in matching the output. If you want to see me build it "live" then watch my video here: https://www.dataprepsolutions.com/2020/02/alteryx-weekly-challenge-203-build.html

[patel_bm]

I managed to resolve this by using a batch macro to prepare data for each ID with respective leg of journey with start/end time.

With overall journey per ID in place, join tolls data by segments and summarize the data to produce the output.

Spoiler

Main Workflow

Spoiler

Batch Macro

[danilang]

Interesting toll structure.  It cost more to go from 3 to 4, than from 3 to 5

@danespoors " I still avoid using regex like the plague".  You say that now, but you'll wake up one day and...

Spoiler

Dan

[jagdeep_singh85]

PFA my solution

[djs28]

I hit a bit of a wall on this after I had transposed the data. I was trying to summarize the data and after a few failures, I had to borrow ideas from other users. Then, I quickly realized I had forgotten to consider the Multi-Row Formula tool to prepare the data for grouping and aggregating.

I have forgotten about the Multi-Row and Multi-Field formula tools on numerous occasions and it would've saved me a decent amount of time and headaches.

Now I'm making sure to favorite these tools in my toolbar for future workflows!

[kylemhabe]

Spoiler