topic Field not found error in the load script in QlikView

Field not found error in the load script

santhosh_k_n — Fri, 11 Jul 2014 07:04:29 GMT

Hi All,

I am facing filed not found error, when applying section access using QVDs, please find the scenario am using

I need to apply section access on 5 field based on the Role but the field on which section access is defined in 3 different qvds.

Access_QVD: Role, NTName

QVD1: Role, Field1

QVD2: Role, Field2,Field3

QVD3: Role,Field4,Field5

My load statement is as follows:

Section access;

Access:

LOAD upper(ROLE) as ROLE,

upper(NTNAME) as NTNAME

FROM

Access.qvd

left join

Load ROLE,

FIELD1;

LOAD upper(Role) as ROLE,

upper(Field1) as FIELD1

FROM

QVD1.qvd

(qvd);

Load ROLE,

FIELD2,

FIELD3;

LOAD upper(Role) as ROLE,

upper(Field2) as FIELD2

upper(Field3) as FIELD3

FROM

QVD2.qvd

(qvd);

Left join

Load ROLE,

FIELD4,

FIELD5;

LOAD upper(Role) as ROLE,

upper(Field4) as FIELD4

upper(Field5) as FIELD5

FROM

QVD2.qvd

(qvd);

Section application;

The load statement is running fine till QVD2 load but throws Field not foung error while loading FIELD4

Please guide me

Re: Field not found error in the load script

Fri, 11 Jul 2014 07:06:12 GMT

change your last statement to look at QVD3 and not QVD2

Re: Field not found error in the load script

santhosh_k_n — Fri, 11 Jul 2014 07:10:14 GMT

Its a Typo error, the load statement is as follows,

Section access;

Access:

LOAD upper(ROLE) as ROLE,

upper(NTNAME) as NTNAME

FROM

Access.qvd

left join

Load ROLE,

FIELD1;

LOAD upper(Role) as ROLE,

upper(Field1) as FIELD1

FROM

QVD1.qvd

(qvd);

Load ROLE,

FIELD2,

FIELD3;

LOAD upper(Role) as ROLE,

upper(Field2) as FIELD2

upper(Field3) as FIELD3

FROM

QVD2.qvd

(qvd);

Left join

Load ROLE,

FIELD4,

FIELD5;

LOAD upper(Role) as ROLE,

upper(Field4) as FIELD4

upper(Field5) as FIELD5

FROM

QVD3.qvd

(qvd);

Section application;