Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Link Table Help on a Sample

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.

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

8 Replies
Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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)

Capture.PNG

Not applicable
Author

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

                                            export.png

Your model will look like this.

Thanks,

Mukram.

Not applicable
Author

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

Capture3.PNG

Capture4.PNG

Not applicable
Author

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.

fosuzuki
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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.