Apply Map Question - Using a range of values

[#1]

Hi

Is it possible to use the APPLY MAP function for a range of values?

The scenario i have is that i have a filed containing a number, this number relates to a duration (in days)

e.g. 1.032424

What I want to do is to categorise this duration into a banding, for instance '1 to 3 days'

So i want to take my original table, and create a new field for each row which states the band that each duration falls into

Duration Band

1.02323 1 to 3 days

0.5656 Less than 1 day

5.5353 3 days to 1 week

.... and so on

So the sort of mapping i need to carry out is dependent on the number range the duration falls in

< 1 maps to 'Less than 1 day'

>= 1 AND < 3 maps to '1 to 3 days'

Can this be done, my research suggests that an apply map is the tidiest way to do it, but the only examples i can find are exact mappings, and don't cater for ranges such as this.

Is this possible?

Thanks in advance

[#2]

Hi,

please see if this example is helpful to slove your requirement.

Good luck!

Rainer

[#3]

Thanks Rainer, I'm still using the personal edition, so i guess i won't be able to open this without messing up my licence.. any chance you could copy and paste the bits of the script that do this in your example?

Cheers!

Matt

[#4 · Accepted solution]

O.K!

Now you can open this version by personal edition without any problems.

We tested it some times and it was succesful.

Rainer

[#5]

Perfect, thank you