I am trying to do something as below in QlikView using 2 resident tables. Both tables are loaded from different data sources so I could not make the join at DB level.
TEAM_DATA table has entire team hierarchy and ENTITLEMENTS table has permissioning defined at different team levels.
Can someone please point me in right direction to code something like this... I am planning to load 6 seperate tables (6 joins one for each team level) and then combine them all together... would really appreciate if someone can provide better idea..
Thanks in advance !
<pseudo code>
[TEAM_ENTITLEMENT_LINK]:
load
distinct
[ENTITLEMENTS].TEAM_LINK,
[TEAM_DATA].TEAM_LEVEL_1_ID
resident
[ENTITLEMENTS],[TEAM_DATA]
where
[ENTITLEMENTS].TEAM_LINK IS NOT NULL
and
(
[TEAM_DATA].TEAM_LEVEL_6_ID = [ENTITLEMENTS].TEAM_LEVEL_6_ID
OR [TEAM_DATA].TEAM_LEVEL_5_ID = [ENTITLEMENTS].TEAM_LEVEL_5_ID
OR [TEAM_DATA].TEAM_LEVEL_4_ID = [ENTITLEMENTS].TEAM_LEVEL_4_ID
OR [TEAM_DATA].TEAM_LEVEL_3_ID = [ENTITLEMENTS].TEAM_LEVEL_3_ID
OR [TEAM_DATA].TEAM_LEVEL_2_ID = [ENTITLEMENTS].TEAM_LEVEL_2_ID
OR [TEAM_DATA].TEAM_LEVEL_1_ID = [ENTITLEMENTS].TEAM_LEVEL_1_ID
);
</pseudo code>