Avoiding automatic associations of tables

[Anonymous]

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

[Anil_Babu_Samineni]

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

[Anonymous]

but i need to have same name for all right?

[oscar_ortiz · Accepted solution]

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]

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