topic Re: getting the data at some field level in QlikView

getting the data at some field level

Anonymous — Thu, 14 Sep 2017 05:23:04 GMT

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 — Thu, 14 Sep 2017 05:26:05 GMT

This?

Load id1 as id1 from T1;

Join

Load id2 as id1 from T2;

Anonymous — Thu, 14 Sep 2017 05:56:31 GMT

do we require to do group by as well?

afsarshaikh — Thu, 14 Sep 2017 05:59:00 GMT

Try,

Table1:

LOAD ID

FROM XYZ;

LEFT JOIN (Table1)

Table2:

LOAD ID

FROM XYZ;

LEFT JOIN (Table1)

Table3:

LOAD ID

FROM XYZ;