getting the data at some field level

[Anonymous]

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

[Anil_Babu_Samineni]

This?

Load id1 as id1 from T1;

Join

Load id2 as id1 from T2;

[Anonymous]

do we require to do group by as well?

[afsarshaikh]

Try,

Table1:

LOAD ID

FROM XYZ;

LEFT JOIN (Table1)

Table2:

LOAD ID

FROM XYZ;

LEFT JOIN (Table1)

Table3:

LOAD ID

FROM XYZ;