Join based on lower and upper number

Hi all,

I have a lot of lines so I was wondering on the best practice on how to do a join (or maybe it doesn't matter to much for runtime if its a neat solution or not). Its probably easiest to explain by just showing example data I created:

On one of the inputs I have a range of numbers. Sometimes it is not a range then the number is only specified in the 'beginzone'. The join needs to lookup the leadtime value depending on the zone.

The alteryx attachment contains the inputs as text.

Cheers!

Join by range.yxmd

Workflow

Accepted answers

Here is how you can do it. Using generate rows tool to generate numbers between range and later map them.

Workflow:

Hope this helps : )

Join by range.yxmd

All comments

Here is how you can do it. Using generate rows tool to generate numbers between range and later map them.

Workflow:

Hope this helps : )

Join by range.yxmd

Thank you @atcodedog05 , very good, I can adjust this based on some other reqs to get the job done!

Happy to help : ) @Pingu

Cheers and have a nice day!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703