Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Avoiding automatic associations of tables

I have 3 tables say A, B and C. And I have a common column name in all the 3 named 'Savings'.

I need to have association with A and C as well as B and C using the column name 'Savings'. But I want to prevent the association happening between A and B (automatic association happens as they both have common column name).

How can I implement this?

Please help on this.

Thanks in advance

1 Solution

Accepted Solutions
oscar_ortiz
Partner - Specialist
Partner - Specialist

You may try something like this:

TableA:

Load

     FieldA,

     FieldB,

     FieldC,

     CommonField as Key1

From TableA;

TableB:

Load

     FieldX,

     FieldY,

     FieldZ,

     CommonField as Key1,

     CommonField as Key2

From TableB;

TableC:

Load

     Field1,

     Field2,

     Field3,

     CommonField as Key2

From TableB;

Although if the values of your common field are the same in all three tables then why not let Qlik associate the common fields.  If some values of the common field associate to Table A and others to Table B then this might work.

Good luck

Oscar

View solution in original post

4 Replies
Anil_Babu_Samineni

May be using Noconcatenate for that table or Use Qualify for that field ??

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

but i need to have same name for all right?

oscar_ortiz
Partner - Specialist
Partner - Specialist

You may try something like this:

TableA:

Load

     FieldA,

     FieldB,

     FieldC,

     CommonField as Key1

From TableA;

TableB:

Load

     FieldX,

     FieldY,

     FieldZ,

     CommonField as Key1,

     CommonField as Key2

From TableB;

TableC:

Load

     Field1,

     Field2,

     Field3,

     CommonField as Key2

From TableB;

Although if the values of your common field are the same in all three tables then why not let Qlik associate the common fields.  If some values of the common field associate to Table A and others to Table B then this might work.

Good luck

Oscar

effinty2112
Master
Master

Hi Faris,

You can duplicate the linking field in table B under a new name. Rename the field in table C to the new name of the duplicate field in table B.

In table A have field Savings

In table B have field Savings and Savings1 (duplicate)

In table C have field Savings1

Cheers

Andrew