Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

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
PrashantSangle

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

3 Replies
PrashantSangle

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
priyarane
Specialist
Specialist
Author

SOMETHING WRONG OVER HERE

priyarane
Specialist
Specialist
Author

after doing cosmetic changes it working based your logic thanks