topic Re: Join in QlikView

Join

priyarane — Tue, 04 Apr 2017 08:31:20 GMT

Hi Community,

Can some one pls help me to create Datamodel by using below join.

from T_CDR t

left join cd_users u on t.issuer_id =u.user_id

left join T_CDR t_d on t.child_id = t_d.id

left join cd_users u_d on t_d.issuer_id =u_d.user_id

I have already loaded and created QVDs for T_CDR,cd_users.

-Priya

PrashantSangle — Tue, 04 Apr 2017 08:41:06 GMT

Load user_id,child_id,field1,field2 from t_cdr

Left Join

Load user_id,cd_user_field1,cd_user_field2 from cd_user

Left join

Load id as child_id,issuer_id as t_d_issuer_id, field1,field2 from t_cdr

left join

Load user_id as t_d_issuer_idm,cd_user_field1,cd_user_field2 from cd_user

Rename or load fields as per requirement.

Regards,

priyarane — Tue, 04 Apr 2017 10:26:03 GMT

SOMETHING WRONG OVER HERE

priyarane — Thu, 06 Apr 2017 18:11:21 GMT

after doing cosmetic changes it working based your logic thanks