Dynamic range

Hi

How do I solve this:

lets say I have a post code mapping files.
1 - 100 - Zone 1
101 - 200 - Zone 2 and so on.

Then I wanna add my input data that has a postalcode 75 - then it add's Zone 1 to that row.

Without having to do a join and then a filter... because i have millions of input rows and hundreds of mapping rows.

?

zones.yxmd

Input

Accepted answers

DawnDuong

hi @Hamder83

I do a simple mock-up workflow here. You can make tweaks to the tools upstreams of the filter if your exact data inputs are different. But the idea is the same as the schema I explained in the earlier reply.

Hope it helps.

Dawn.

CodeToRegion.yxzp

All comments

apathetichell

your data didn't post - you'd have to use it as a text input or use the export workflow to have your data post with your workflow - having said that, perhaps a TILE tool set to manual option - where you can then use your zone cutoffs in the manual option...

DawnDuong

Hi @Hamder83

If your boundary conditions are fixed and known, you can used a Formula tool and if then elseif else endid syntax to get the additional column.

do you need the upper and lower boundaries to be dynamic inputs?

dawn

Hamder83

I will take a look into that, thanks 🙂

Hamder83

Hi @DawnDuong ,

I would pref for it to be dynamic, since we are using a similar methodoligy for several mappings, weight and so on.
Which is not always equal in our input to our mapping tables.

So I was hoping to find something that was not hard coded into a formular.

Hamder83

hi @DawnDuong

May I ask you to take a look at my previous msg, if you have a few mins at some point?

I'm sorry, it seems like such a good solution, but im not even skilled enough to make it work on my acual data :'(

WeightToPrice (1).yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703