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 );
