Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a hierarchy from three tables.

Dear all,

I have the following Question:

I have three tables like this:

Field: A B C

Table 1: 1

Table 2: 1 2

Table 3: 2 3

Now i need to create a table the shows the folowing information:

Tabel 4: A B C

Row 1: 1 - -

Row 2: 1 2 -

Row 3: 1 2 3

It's a Hierachy. Does anyone know how to do this?

Regards,

Frank

4 Replies
suniljain
Master
Master

pls check attached file.

Not applicable
Author

Thanks for your quick response!

I don't think this is my awnser (or maybe i am wrong).

Your Products ' hierarchy' is found inside ONE table 'Ancestors' , but I have THREE tables.

Not applicable
Author

Hi fbeunder,

Could you please explain the problem with more data from each table1,table2 and table3?

Not applicable
Author

Field: A B C

Table 1: 1

2

Table 2: 1 2

1 4

2 2

Table 3: 2 3

4 5

Tabel 4: A B C

Row 1: 1 - -

Row 2: 1 2 -

Row 3: 1 2 3

Row 4: 1 4 -

Row 5: 1 4 5

Row 6: 2 - -

Row 7: 2 2 -

Row 8: 2 2 4

Is this sufficient?