Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

priyarane
Contributor III

Join

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

1 Solution

Accepted Solutions

Re: Join

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,

Regards,
Prashant Sangle
3 Replies

Re: Join

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,

Regards,
Prashant Sangle
priyarane
Contributor III

Re: Join

SOMETHING WRONG OVER HERE

priyarane
Contributor III

Re: Join

after doing cosmetic changes it working based your logic thanks