ODBC-connection error while IntervalMatch

[#1]

When I run the script an ODBC fail occore.

Whats wrong?

[CODE]

//-- Script ------------

// Load ages intervals and text representation

Age:

LOAD

INLINE

[ AgeStart, AgeEnd,AgeGroup;

//Then load People table without if's

People:

LOAD

Age

FROM

// using intervalmatch function

Result:

IntervalMatch

( ( ( Age ) select AgeStart, AgeEnd from Age; [/CODE] (biff, embedded labels, table is Blad1$) ;Name ,

*

[#2]

//-- Script ------------
// Load ages intervals and text representation
Age:
LOAD * INLINE
[ AgeStart, AgeEnd,AgeGroup
0, 5 ,0 -5 years
6, 10 ,6 - 10 years
11, 18 ,11 - 18 years
19, 30 ,19 - 30 years
31, 65,31 - 65 years
66, 100000,66 and older
];

//Then load People table without if's
People:
LOAD Name,
Age
FROM (biff, embedded labels, table is Blad1$);

// using intervalmatch function
Result:
IntervalMatch ( Age ) select AgeStart, AgeEnd from Age;

[prieper · Accepted solution]

You should replace the "From" with a "Resident", as the table age is already available in memory

HTH
Peter

[#4]

Still the same error.

[prieper]

please also replace the "Select" with a "Load"

Peter