Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Load user_id,child_id,field1,field2 from t_cdr
Load user_id,cd_user_field1,cd_user_field2 from cd_user
Load id as child_id,issuer_id as t_d_issuer_id, field1,field2 from t_cdr
Load user_id as t_d_issuer_idm,cd_user_field1,cd_user_field2 from cd_user
Rename or load fields as per requirement.
SOMETHING WRONG OVER HERE
after doing cosmetic changes it working based your logic thanks