topic Re: Link Table Help on a Sample in QlikView

Link Table Help on a Sample

Fri, 31 Aug 2012 21:08:08 GMT

Hello, can you please help with this much simplified scenario I am wrestling with?

Example:

Table1

ColA (primary key)

ColB

Table2

ColA

ColB

Table3

ColB (primary key)

I need to just load these which will create a loop. I think i just need a Link table, but not exactly sure of the load syntax. Can someone please help?

Thanks very much.

Re: Link Table Help on a Sample

Sat, 01 Sep 2012 04:28:39 GMT

Dear,

if you have more than one comman filed between tables ,than you can do the following approches.

1)Apply the concatenation between the tables, so that tables will be merged as one table.

2)Join the two tables like ,in your sample join table2 and Table 3 ,than rename the filed than goto link with other table1.

hope this one will help you.

Thanks,

Mukram.

Re: Link Table Help on a Sample

Tue, 04 Sep 2012 14:05:01 GMT

Unfortunately I cannot join or contatenate any of these 3 tables. So i need to use a link table and create the keys. I just don't know how to do this in this scenario without creating a loop. Do you?

Thanks,

Richard

Re: Link Table Help on a Sample

Tue, 04 Sep 2012 15:37:28 GMT

In case it helps, here is what QV does to get this to work creating the synthetic key. Basically I just need to create this key during the load the 'right' way instead of letting QV do it for me. But i am struggling......

(slightly different table names in this pic, but the same exact structure as the original post)

Re: Link Table Help on a Sample

Tue, 04 Sep 2012 19:47:38 GMT

Dear,

you can avoid the synthetic key like

Rename the ColB Filed in table1 as NewFiled.

Table1:

ColA ,

ColB as NewField

Table2:

ColA

ColB

Table3:

ColB

Your model will look like this.

Thanks,

Mukram.

Re: Link Table Help on a Sample

Tue, 04 Sep 2012 20:00:30 GMT

Thanks very much. This works fine for table1 to table2 or table2 to table3 selections, but there is no link between table 3 and table 1. So selecting any data in table3 results in incorrect information in table1.

Here is the table layout and some sample data where you can see selecting data in 3 does not have available a connection to get back to the correct data in table1.

Please let me know if you have any idea how to get this to work and THANK YOU AGAIN!

Richard

Re: Link Table Help on a Sample

Tue, 04 Sep 2012 20:47:19 GMT

Dear Richard.

In Your scenario you can do the following options,

1) you can concatenate the tables.

2) you can join the tables.

3) you can make one table as Mapping table.

4) you can use AutoNumber() Function.

Thanks,

Mukram.

Re: Link Table Help on a Sample

fosuzuki — Tue, 04 Sep 2012 21:46:57 GMT

As I see from the sample structure you described, it seems as the tables could be concatenated or joined as mukram suggested.

Anyway, check the attached file for an example with LinkTable.

Hope this helps

Fernando

Re: Link Table Help on a Sample

Thu, 20 Sep 2012 18:22:33 GMT

Using an OUTER JOIN in the key table resolved the issue. Concatenate resulted in multiple rows for each index making it harder (probably not impossible though) to create expressions in the application.