Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
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,
SOMETHING WRONG OVER HERE
after doing cosmetic changes it working based your logic thanks