Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 3 tables joined in my data model,
but first table is at id1 level
table2 is at id2 level
so i need to roll up both tables at id1 level only ,
how to do that
This?
Load id1 as id1 from T1;
Join
Load id2 as id1 from T2;
do we require to do group by as well?
Try,
Table1:
LOAD ID
FROM XYZ;
LEFT JOIN (Table1)
Table2:
LOAD ID
FROM XYZ;
LEFT JOIN (Table1)
Table3:
LOAD ID
FROM XYZ;