HI ALL ,
I HAVE A QVW FILE WHERE SECTION ACCESS IS IMPLETED AS BELOW WANT TO UNDERSTAND HOW THE BELOW CODE WORKS ?
Section Access;
LOAD upper(USERID) AS NTNAME,
upper(ACCESS) AS ACCESS,
'*' AS SERIAL
FROM [$(SectionAccessPath)\Users_MasterGrossMargin.qvw.csv] (ansi, txt, delimiter is ',', embedded labels, msq);
CONCATENATE
LOAD * INLINE [
ACCESS, NTNAME, SERIAL
ADMIN, *, 46XX 6XXX 0XXX 3XXX
];
JOIN
LOAD upper(USERID) AS NTNAME,
upper([REGION]) AS [REGION],
upper([DIVISION]) AS [DIVISION],
upper([PG_MAJOR]) AS [PG_MAJOR]
FROM [$(SectionAccessPath)\GrossMargin.qvw_Data.csv] (ansi, txt, delimiter is ',', embedded labels, msq);
Section Application;
THANKS
ANANT
