Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SECTION Access;
Directory;
load
upper('HK') as FILTER_CENTER_ID,
Upper(ACCESS) AS ACCESS,
Upper (NTNAME) AS NTNAME
// ROLE,
FROM
(ooxml, embedded labels, table is Sheet1);
////////////////////////////////////////////////
SECTION Application;
Directory;
LOAD
Upper (NTNAME) AS NTNAME,
Tab_Main
FROM
(ooxml, embedded labels, table is Sheet2);
//
////*******************************//
KEY_MASTER:
LOAD QA_center,
Office,
COO
FROM
(ooxml, embedded labels, table is Sheet1);
//**********Role Table**********//
ROLE_TABLE:
LOAD Distinct
Upper(QA_center) AS QA_center,
'ALL' AS FILTER_CENTER_ID
Resident KEY_MASTER;
LOAD Distinct
Upper(QA_center) AS "QA_center",
Upper(QA_center) AS FILTER_CENTER_ID
Resident KEY_MASTER;
Above is my code, the FILTER_CENTER_ID key just disappeared after the script is loaded, any ideas?thanks
The Section access table wont be shown in the DataModel that's the reason . You can still the field in the ROLE_TABLE of your datamodel and this is the expected behavior
thanks for your reply dude, however it doesnt connect, the reducing field function not work as expected ;(
Hi,
This happen because of section access statement. Here, the access part will work internally and won't be appear on data model. To check the sync key try to comment section access and section application functions.
Hope it helps
Mohit
Sir, I had checked all but it still doesnt work, would you mind to have a look when you are free? Thanks
Hi,
are you talking about this code
ROLE_TABLE:
LOAD Distinct
Upper(QA_center) AS QA_center,
'ALL' AS FILTER_CENTER_ID
Resident KEY_MASTER;
LOAD Distinct
Upper(QA_center) AS "QA_center",
Upper(QA_center) AS FILTER_CENTER_ID
Resident KEY_MASTER;
In this script both table concatenated therefore you are not getting FILTER_CENTER_ID field as key.
other than this i don't find any table which link with Role_table with FILTER_CENTER_ID
Hope you got what you looking for.
Regards