The syn key disappeared

[#1]

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

[qliksus]

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

[#3]

thanks for your reply dude, however it doesnt connect, the reducing field function not work as expected ;(

[er_mohit]

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

[#5]

Sir, I had checked all but it still doesnt work, would you mind to have a look when you are free? Thanks

[PrashantSangle]

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