topic Re: Two Connection. in QlikView

Two Connection.

Tue, 23 Dec 2014 05:33:40 GMT

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

Re: Two Connection.

Anonymous — Tue, 23 Dec 2014 05:44:20 GMT

Your table should be link with all the tables which you are using in table box.

Re: Two Connection.

Tue, 23 Dec 2014 05:50:49 GMT

Hi masba khandaker,

There is no relation between two data sources tables. make a filed common between two sources then try it out.

Re: Two Connection.

Anonymous — Tue, 23 Dec 2014 05:52:34 GMT

rename your CT.BRAND as Brand_Id .. It will work

Re: Two Connection.

tyagishaila — Tue, 23 Dec 2014 05:54:43 GMT

Instead of Table Box use Straight Table and

in expression use sum(Depot_Pre_Sales_Qty).

Try it,

Re: Two Connection.

padmanabhan_ram — Tue, 23 Dec 2014 06:01:38 GMT

Hi Masba,

I guess the fields in the table object in the UI are from more than one table which should be fields from Oracle table and fields from SQL table. If so please find out a primary key between those tables and link the tables using the primary key and the duplicate rows will be resolved.

Thanks,

Padmanabhan

Re: Two Connection.

rajeshvaswani77 — Tue, 23 Dec 2014 06:04:34 GMT

Masba,

You have synthetic key in the data mode. Concatenate fields Brand_ID, Category_Id, Category_name, Brand_name and create one Link field to link the tables. The rows repeat because the quantity is different. You can always aggregate and have a sum of quantity.

regards,

Rajesh Vaswani

Re: Two Connection.

Anonymous — Tue, 23 Dec 2014 06:05:48 GMT

Use a primary linkage and avoid synthetic keys which will help you..

Thanks,

Vignesh

Re: Two Connection.

Tue, 23 Dec 2014 06:29:57 GMT

Dear Rajesh,

Thanks for your reply.. can you edit my file it will be so much helpful for me as a new learner.

Masba

Re: Two Connection.

alkesh_sharma — Tue, 23 Dec 2014 06:46:56 GMT

I tried but couldn't identify a primary key in your database.

Identify a primary key. and link the tables using the primary key.

Also the Brand_ID and Brand Code contain the same values, Rename Brand Code as Brand ID and link that table as well.

Re: Two Connection.

sujeetsingh — Tue, 23 Dec 2014 06:56:50 GMT

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

Re: Two Connection.

Tue, 23 Dec 2014 06:59:46 GMT

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..

Re: Two Connection.

Tue, 23 Dec 2014 07:11:36 GMT

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.

Re: Two Connection.

alkesh_sharma — Tue, 23 Dec 2014 07:23:47 GMT

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.

Re: Two Connection.

Tue, 23 Dec 2014 08:50:43 GMT

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

Re: Two Connection.

alkesh_sharma — Tue, 23 Dec 2014 09:03:44 GMT

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

Re: Two Connection.

Tue, 23 Dec 2014 09:12:40 GMT

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

Re: Two Connection.

alkesh_sharma — Tue, 23 Dec 2014 09:25:19 GMT

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