topic Re: Linking Tables in QlikView

Linking Tables

Wed, 30 Mar 2016 07:15:07 GMT

Hi, I have 3 tables that include the same column but the relationships should be 1 to 2, 1 to 3 and not 2 to 3 can this be done?

TIA

Re: Linking Tables

jonathandienst — Wed, 30 Mar 2016 11:10:22 GMT

Please explain what you need in more detail, preferably with an example that shows what you have and what you are trying to get to.

Re: Linking Tables

sunny_talwar — Wed, 30 Mar 2016 11:12:33 GMT

Do you have a sample you can share?

Re: Linking Tables

Anonymous — Wed, 30 Mar 2016 11:17:14 GMT

you should define additional fields

Table1:

commonfield as %1to2

commonfield as %1to3

commonfield,

elsefield,

Table2:

commonfield as %1to2

otherfields,

Table3:

commonfield as %1to3

morefields

but donot load explicitly commonfield for Table2 and Table3

Re: Linking Tables

buzzy996 — Wed, 30 Mar 2016 11:26:49 GMT

yes,rename the fields whichever the way u like to join.

Re: Linking Tables

Wed, 30 Mar 2016 11:36:17 GMT

Hello,

This is what you need?

table1:

LOAD

[same column],

Value,

[same column] AS [same column3];

LOAD * INLINE [

same column, Value

1, 1021

2, 321

3, 23145

4, 321

];

table2:

NoConcatenate

LOAD * INLINE [

same column, quantity

1, 4

2, 2

3, 5

4, 8

];

table3:

NoConcatenate

LOAD

[same column] AS [same column3],

sort_order;

LOAD * INLINE [

same column, sort_order

1, 1

2, 2

3, 3

4, 4

];