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
