topic Datamodel in QlikView

Datamodel

Nagaraju_KCS — Tue, 10 Sep 2013 05:53:03 GMT

Hi All,

I am New to Qlikview

Modifying the databases is not allowed

i want to resolve the Synthetic key.

Concatenate and join which one is Better..

Thanks In Advance..

Re: Datamodel

Tue, 10 Sep 2013 05:59:34 GMT

Hi,

Plese rename the unity price with some alias so that you can remove the synthetic key.

The synthetic only forms when we have more that one table with more that one primary key and same set of fields.

Or you can use qulaify and unqualify for the unit price field. Hope it helps you

Thanks and regards,

S.Amuthabharathi

Re: Datamodel

Nagaraju_KCS — Tue, 10 Sep 2013 06:04:25 GMT

Hi Amuthab'

I know this concept Alias name and Qualify.

Yesterday i faced this question..

but, they are asked

Modifying the databases is not allowed.

if i am give Alias name like modified right..

Re: Datamodel

er_mohit — Tue, 10 Sep 2013 06:07:39 GMT

just rename the untpirce feild from order table nothing to do your productid is primary key you got the solution

if your product table has large rows than to order table then try to use left keep

Product table:

load *

from table;

left keep

Order:

load *

from table;

Re: Datamodel

Tue, 10 Sep 2013 06:10:59 GMT

Hi,

Modifying database is not allowed k but giving alias name and using qulaify is not modifying database based on my understanding it just for avoiding synthetic key or circular referance your database will remains as such

Re: Datamodel

tresB — Tue, 10 Sep 2013 06:25:05 GMT

Hello Raju,

Is there any specific reason that you want to remove synthetic keys? It is not necessary that the model with synthetic keys is a wrong one, sometimes it would even give you a better performance. Please have a look at this important discussion about synthetic keys in model

Re: Datamodel

Tue, 10 Sep 2013 06:27:49 GMT

Hi,

To resolve the synthetic key just rename one of the columns using Alias. Aliasing does not mean that you are modifying database, it just renames the column in qlikview so that the column is not joined with any other similar named column (Which is qlikview's default attribute).

Just use UnitPrice as below along with all other fields you want:

Product table:

Load

Unitprice as UnitPrice1

From table;

This way you will just have one common column ProductID across tables on which the tables will be joined and no Synthetic key/table will be formed.

Hope this helps!

Re: Datamodel

rajeshvaswani77 — Tue, 10 Sep 2013 06:30:22 GMT

You are modifying your QlikView table, not the database table.

thanks,

Rajesh Vaswani