Need some help here.

[#1]

Hello all
Im totally new in QV.

I have problem with delivery company report.
I have table like this:

load * inline [
country, postal1, postal2, zone
AB, 1000-2000, 1000-3000, 1
AB, 1000-2000, 3001-5000, 2
AB, 1000-2000, other, 4
AB, 2001-4000, , 3
AB, 4001-5000, , 1
AC, , 1000-2500, 9
AC, , 2501-3000, 7
AC, , other, 2
AZ, , , 5
..................
];

I have postal code from other table like AB, 2540. I need when i select postal code it should show zone number defend on postal1 and postal2. But some countries have postal1 but dont have postal 2, some are don't have postal1 but have postal2, some are dont have bot of them and some are have bot of them.
please help me. Its making real headache for me now.

[#2]

hey someone any ideas to do this.

[Miguel_Angel_Baeyens]

Hi,

Check the document attached. It's not clear when a postalcode belongs to one of each postal1 or postal2, if you need to keep comparing or what.

You will likely need to change the script to fit your needs, anyway, the Intervalmatch() seems to return some probable values. Data will need some cleanup as well, since Intervalmatch() only works with numeric values ("other" will return unexpected results).

Hope that helps.

[#4]

Hi Miguel

im really glad to hear something from you.
Now I'm trying to use intervalmatch in my data as you suggest.
After that i'll post.

Thank you.