How to join using different fields

Wed, 12 Jan 2011 17:51:49 GMT

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 !

[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>

topic How to join using different fields in QlikView

How to join using different fields