Join based on lower and upper number

[Pingu]

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!

[atcodedog05 · Accepted solution]

Hi @Pingu 

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

Workflow:

Hope this helps : )

[Pingu]

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

[atcodedog05]

Happy to help : ) @Pingu 

Cheers and have a nice day!