Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Mark18
Contributor II
Contributor II

how to link two tables to main table without linking them

Hi Guys,

I have three different tables. A ,B,C 

All of them have a column called XYZ. I know that if we have same column name in two different tables it will automatically be linked. But the problem is as follows:

A here is the parent table. B and C are derived from it.

How can i link A and B & A and C by using column XYZ without linking B and C.

 

 

 

3 Replies
JuanGerardo
Partner
Partner

NewA:

Load XYZ AS XYZ_A

Resident A;

 

NewB:

Load XYZ AS XYZ_A,

Load XYZ AS XYZ_B

Resident B;

 

NewC:

Load XYZ AS XYZ_B

Resident C;

 

JG

Mark18
Contributor II
Contributor II
Author

For this the association will be 

A linked to B 

B linked to C 

Right?

 

 

 

 

 

 

 

JuanGerardo
Partner
Partner

Right, I understood A --> B --> C, in case A --> B and A --> C, you could use:

NewA:

Load

XYZ AS XYZ_B,

XYZ AS XYZ_C

Resident A;

 

NewB:

Load XYZ AS XYZ_B

Resident B;

 

NewC:

Load XYZ AS XYZ_C

Resident C;