topic ODBC-connection error while IntervalMatch in QlikView

ODBC-connection error while IntervalMatch

Tue, 08 Dec 2009 01:22:53 GMT

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 ,

*

ODBC-connection error while IntervalMatch

Tue, 08 Dec 2009 01:26:13 GMT

//-- 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;

ODBC-connection error while IntervalMatch

prieper — Tue, 08 Dec 2009 03:48:27 GMT

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

HTH
Peter

ODBC-connection error while IntervalMatch

Tue, 08 Dec 2009 04:45:22 GMT

Still the same error.

ODBC-connection error while IntervalMatch

prieper — Tue, 08 Dec 2009 04:49:19 GMT

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

Peter