Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Need to Concatenate Data from 2 in memory table but throwing error Table not found. Please see below Script. Please correct the Script if any syntax error.
I am getting ERROR:"Table not found CONCATENATE LOAD * RESIDENT DIM_ADMIN_DATA"
DIM_USER_DATA:
LOAD
'USER' END AS ACCESS,
[EMP NAME] AS USERID,
[EMP NAME] AS PASSWORD,
EMP_KEY AS _EMP_KEY
FROM DIM_EMP_DATA.QVD (qvd);
DIM_ADMIN_DATA:
LOAD * INLINE
[
ACCESS, USERID, PASSWORD, _EMP_KEY
ADMIN, ADMIN, ADMIN, *
];
Section Access; /* Start section access script */
LOAD *
RESIDENT DIM_USER_DATA;
CONCATENATE
LOAD *
RESIDENT DIM_ADMIN_DATA;
Section Application; /* End section access script */
Hi All,
This does not work (It is not allowing other that ADMIN USER to access QVW)
DIM_USER_DATA:
LOAD
'USER' AS ACCESS,
[EMP NAME] AS USERID,
[EMP NAME] AS PASSWORD,
EMP_KEY AS _EMP_KEY
FROM DIM_EMP_DATA.QVD (qvd);
NOCONCATENATE
DIM_ADMIN_DATA:
LOAD * INLINE
[
ACCESS, USERID, PASSWORD, _EMP_KEY
ADMIN, ADMIN, ADMIN, *
];
Section Access; /* Start section access script */
LOAD *
RESIDENT DIM_USER_DATA;
CONCATENATE
LOAD *
RESIDENT DIM_ADMIN_DATA;
Section Application; /* End section access script */
This does not work: (Not Allowing any User to access QVW even for ADMIN it is failing)
Section Access; /* Start section access script */
DIM_USER_DATA:
LOAD
'USER' AS ACCESS,
[EMP NAME] AS USERID,
[EMP NAME] AS PASSWORD,
EMP_KEY AS _EMP_KEY
FROM DIM_EMP_DATA.QVD (qvd);
NOCONCATENATE
DIM_ADMIN_DATA:
LOAD * INLINE
[
ACCESS, USERID, PASSWORD, _EMP_KEY
ADMIN, ADMIN, ADMIN, *
];
LOAD *
RESIDENT DIM_USER_DATA;
CONCATENATE
LOAD *
RESIDENT DIM_ADMIN_DATA;
Section Application; /* End section access script */
But this is working as expected and It is also not showing DIM_USER_DATA to user (In Selection list) as it is under Section Access;
Section Access; /* Start section access script */
DIM_USER_DATA:
LOAD
'USER' AS ACCESS,
[EMP NAME] AS USERID,
[EMP NAME] AS PASSWORD,
EMP_KEY AS _EMP_KEY
FROM DIM_EMP_DATA.QVD (qvd);
//NOCONCATENATE
DIM_ADMIN_DATA:
LOAD * INLINE
[
ACCESS, USERID, PASSWORD, _EMP_KEY
ADMIN, ADMIN, ADMIN, *
];
LOAD *
RESIDENT DIM_USER_DATA;
//CONCATENATE
//LOAD *
//RESIDENT DIM_ADMIN_DATA;
Section Application; /* End section access script */
Pls try below code, it is working for both access type.
LOAD * INLINE [
ACCESS, USERID, PASSWORD, _EMP_KEY
USER, MANOJ, MANOJ, 12
USER, EMP1, EMP1, 13
];
DIM_ADMIN_DATA:
LOAD * INLINE
[
ACCESS, USERID, PASSWORD, _EMP_KEY
ADMIN, ADMIN, ADMIN, *
];
STAR is *;
Section Access; /* Start section access script */
LOAD *
RESIDENT DIM_USER_DATA;
Section Application; /* End section access script */
Hide prefix will work only for fields. Below content from Qlikview help file.
All field names beginning with this text string will be hidden in the same manner as the system fields. A user-defined variable.
Example:
set HidePrefix='_' ;
If this statement is used, the field names beginning with an underscore will not be shown in the field name lists when the system fields are hidden