How to Create Generic Keys for Common table Fields?

jgarciaf106 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to create generic Keys to group common fields form some data tables I have Into Qlikview,

But when loading the script it warms me about "One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. Loop(s) will be cut by setting one or more tables as loosely coupled." , even-though the common fields are not named the same (EX: HC_MONTH, ES_MONTH and it goes in that trend for all all tables) it creates the loop.

Here Is the Script I Used:

// Dimensional Tables//

[Dimensional Cluster]:

Load `ES_CLUSTER`, `ES_CLUSTER` As %CLUSTER Resident EXIT_SURVEY;

Concatenate([Dimensional Cluster])

Load `HC_CLUSTER`, `HC_CLUSTER` As %CLUSTER Resident HEAD_COUNT;

Concatenate([Dimensional Cluster])

Load `Promo_CLUSTER`, `Promo_CLUSTER` As %CLUSTER Resident PROMOTION;

Concatenate([Dimensional Cluster])

Load `PDP_CLUSTER`, `PDP_CLUSTER` As %CLUSTER Resident PDP;

Concatenate([Dimensional Cluster])

Load `Reco_CLUSTER`, `Reco_CLUSTER` As %CLUSTER Resident RECOGNITION;

Concatenate([Dimensional Cluster])

Load `Reme_CLUSTER`, `Reme_CLUSTER` As %CLUSTER Resident REMEDY;

Concatenate([Dimensional Cluster])

Load `Tal_CLUSTER`, `Tal_CLUSTER` As %CLUSTER Resident TALENT;

Concatenate([Dimensional Cluster])

Load `TalPro_CLUSTER`, `TalPro_CLUSTER` As %CLUSTER Resident TALENT_PROFILE;

Concatenate([Dimensional Cluster])

Load `TO_CLUSTER`, `TO_CLUSTER` As %CLUSTER Resident TURN_OVER;

Concatenate([Dimensional Cluster])

Load `VC_CLUSTER`, `VC_CLUSTER` As %CLUSTER Resident VOC;

[Dimensional Country]:

Load `ES_COUNTRY`, `ES_COUNTRY` As %COUNTRY Resident EXIT_SURVEY;

Concatenate([Dimensional Country])

Load `HC_COUNTRY`, `HC_COUNTRY` As %COUNTRY Resident HEAD_COUNT;

Concatenate([Dimensional Country])

Load `Promo_COUNTRY`, `Promo_COUNTRY` As %COUNTRY Resident PROMOTION;

Concatenate([Dimensional Country])

Load `PDP_COUNTRY`, `PDP_COUNTRY` As %COUNTRY Resident PDP;

Concatenate([Dimensional Country])

Load `Reco_COUNTRY`, `Reco_COUNTRY` As %COUNTRY Resident RECOGNITION;

Concatenate([Dimensional Country])

Load `Reme_COUNTRY`, `Reme_COUNTRY` As %COUNTRY Resident REMEDY;

Concatenate([Dimensional Country])

Load `Tal_COUNTRY`, `Tal_COUNTRY` As %COUNTRY Resident TALENT;

Concatenate([Dimensional Country])

Load `TalPro_COUNTRY`, `TalPro_COUNTRY` As %COUNTRY Resident TALENT_PROFILE;

Concatenate([Dimensional Country])

Load `TO_COUNTRY`, `TO_COUNTRY` As %COUNTRY Resident TURN_OVER;

Concatenate([Dimensional Country])

Load `VC_COUNTRY`, `VC_COUNTRY` As %COUNTRY Resident VOC;

[Dimensional Location]:

Load `ES_LOCATION`, `ES_LOCATION` As %LOCATION Resident EXIT_SURVEY;

Concatenate([Dimensional Location])

Load `HC_LOCATION`, `HC_LOCATION` As %LOCATION Resident HEAD_COUNT;

Concatenate([Dimensional Location])

Load `Promo_LOCATION`, `Promo_LOCATION` As %LOCATION Resident PROMOTION;

Concatenate([Dimensional Location])

Load `PDP_LOCATION`, `PDP_LOCATION` As %LOCATION Resident PDP;

Concatenate([Dimensional Location])

Load `Reco_LOCATION`, `Reco_LOCATION` As %LOCATION Resident RECOGNITION;

Concatenate([Dimensional Location])

Load `Tal_LOCATION`, `Tal_LOCATION` As %LOCATION Resident TALENT;

Concatenate([Dimensional Location])

Load `TalPro_LOCATION`, `TalPro_LOCATION` As %LOCATION Resident TALENT_PROFILE;

Concatenate([Dimensional Location])

Load `TO_LOCATION`, `TO_LOCATION` As %LOCATION Resident TURN_OVER;

Concatenate([Dimensional Location])

Load `VC_LOCATION`, `VC_LOCATION` As %LOCATION Resident VOC;

[Dimensional Business Unit]:

Load `ES_BUSINESS_UNIT`, `ES_BUSINESS_UNIT` As %BUSINESS_UNIT Resident EXIT_SURVEY;