topic Re: Header & details Table ? in QlikView

Header & details Table ?

Sun, 14 Feb 2016 18:24:04 GMT

Hi All,

We are Having Various Header tables & Details Table..

HOw we Can Link them ? On what we need to provide the Link..

Can any one Share the Document related to this ...

Regards,

Helen

Re: Header & details Table ?

sunny_talwar — Sun, 14 Feb 2016 18:26:06 GMT

Not sure what you are looking to do. Would you be able to elaborate?

Re: Header & details Table ?

Sun, 14 Feb 2016 18:31:59 GMT

Thanks..

In header table having 1 record, In details table having some 10 records related to that specific record in header table..

how to maintain the relation ?

Re: Header & details Table ?

sunny_talwar — Sun, 14 Feb 2016 18:36:11 GMT

If there is a unique key which connect the two tables, then the connection between the two tables can be made by making sure that both tables name the unique key with the same name.

HeaderTable:

LOAD CustomerID,

CustomerName,

CustomerAddress,

...

FROM Source1;

DetailTable:

LOAD TransactionNum,

TransactionAmt,

TransactionDate,

CustomerID,

....

FROM Source2;

Re: Header & details Table ?

maxgro — Sun, 14 Feb 2016 18:47:25 GMT

You need one or more fields with the same name in the header and detail table

The logical key of the detail will be the logical key of the header and some other fields

Example

OrderHeader OrderNo

OrderDetail OrderNo + OrderLineNo