Two Connection.

[#1]

Dear QV experts,

I have two database connection. One with Orcale and another one with Sql Server. when i wants to show data in one table box that time multiple rows comes..How can i solve this problem...Please help me.. For your better understanding i have attached my file...

Regards,

Masba

[sujeetsingh]

The first thing i want to warn you never post real time data in community.

Well no one can tell you the best suited primary key for the requirement you need.

Hence you have to think couple of questions before you go to develop the data model

- What you need to represent

- for what details you need the second table

- what fields and filters you are going to use from the second table

- If you are going to implement some derieved fields from two tables then you need to join the both.

Now find the answers for these.

Well your second table has BrandID, and CategoryID you can use any of the two as primary key to associate.

Thanks

[#3]

Dear Alkesh,

In my database "Brand Id" and "Category Id" is primary key..also i have rename Brand Code as a 'Brand" but result is same..

[#4]

Dear sujeethsingh,

Thanks for your advise..

1. I need to represent data Brand wise and Category wise

2. My Frist table contain Brand wise and Category wise Retail sale and my second table contain Brand wise and Category wise Whole Sale.

3. From Second table i want use "Depot_Pre_Sales_Qty" this field based on Brand and Category.

[alkesh_sharma]

Masba,

Brand ID and Category ID cannot be primary keys as they are repeated in your data.

Primary IDs cannot repeat.

They can be primary keys of Brand Master Table but your transaction table should also have Primary Key.

Which is missing.

[#6]

Dear Alkesh,

As per your sugesstion i have updated my script and create one primary key by combination of Brand_id and Category id but still now same problem..For your better understanding i have attached my file.

Masba

[alkesh_sharma · Accepted solution]

Remove the synthetic key, Link the two unlinked tables. by renaming BR_CT as Br_Ct as the other primary keys.

[#8]

Dear Alkesh,

Thanks for your valuable time.. As a new learner ur suggesstion will help me lot.. I'm not clear about your keyword "synthetic key". Is it possible for you to edit my file please.

Masba

[alkesh_sharma]

Hit Ctrl+T on the qlikview, you will see the table viewer.

This will show you tables and connection between them..

Here all the tables should be connected to one key only. all the tables should be connected to each other.

You can read more about Synthetic Keys and how to remove them

http://community.qlik.com/message/607162#607162