topic Re: How to make 2 tables from one in QlikView

How to make 2 tables from one

Anonymous — Fri, 27 Mar 2015 10:09:35 GMT

All good health

There are table describes the article and sub

structure:

The foreign key Name, Internal key

If the internal key is null, it is article,

if the internal key is not null, it is a subarticle

How to make two lists Article and subarticle?

the example table

PaymentTypeId ; Name ; ParentId

-1 ; System ; null

0 ; Depositing ; -1

1 ; Payment document ; -1

10 ; Manager ; null

11 ; Receipts ; 10

12 ; Documents ; 10

Peter_Cammaert — Fri, 27 Mar 2015 16:21:51 GMT

For example, these two LOAD statements separate articles from subarticles but keep their relations...

Articles:

LOAD PaymentTypeId AS ArticleId, Name AS ArticleName

FROM YourDataSource

WHERE len(trim(ParentId)) = 0;

SubArticles:

LOAD ParentId AS ArticleId, PaymentTypeId As SubArticleId, Name As SubArticleName

FROM YourDataSource

WHERE len(trim(ParentId)) > 0;

pokassov — Fri, 27 Mar 2015 17:12:29 GMT

or instead of

Where len(trim(ParentId)) = 0

we can use this condition for Articles

Where IsNull(ParentId)

and for SubArticles:

Where Not IsNull(ParentId)

buzzy996 — Fri, 27 Mar 2015 17:20:17 GMT

u can follow pcammaert advice.

Anonymous — Mon, 30 Mar 2015 06:40:59 GMT

Thank you for your help, very helpful