Field not found error in the load script

[santhosh_k_n]

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

[#2]

change your last statement to look at QVD3 and not QVD2

[santhosh_k_n]

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;