topic Re: Re: link table in QlikView

link table

Nagaraju_KCS — Sat, 30 Nov 2013 05:54:31 GMT

Hi Community,

PFA,

i have a requirement,

in my tables these are my common field

BRANCH, SERVICE_CENTER and SAMPLE_MONTH

how to create linktable.

Thanks in Advance

Re: link table

Anonymous — Sat, 30 Nov 2013 07:46:14 GMT

Hi,

I can see you joined all tables with FILE_NO in your model,

are these field values(BRANCH, SERVICE_CENTER and SAMPLE_MONTH) same across all tables for each of File_NO? If so why don't you keep these fields in DatabaseData table and comment out these from rest of the tables.

Can you

Thanks,

JaswantC.

Re: Re: link table

Anonymous — Sat, 30 Nov 2013 10:06:57 GMT

I would concatenate all the Fact Tables into a single Fact Table whilst renaming the variants on the field names BRANCH, SERVICE_CENTER and SAMPLE_MONTH, so that they are all the same and associate accordingly.

Indeed it looks as if all the tables are Fact Tables so you will end up with just one table and so no joins in your Data Model.

Before I got into concatenating such Fact Tables my knee jerk was against it but now I am a convert to it. I remember hic wrote a Blog Post about this some while back that I cannot find it, if anyone can find it and post a link to it I would be most grateful as he explains the pro's & con's of it far than I ever would.

Best Regards, Bill

Re: link table

Nagaraju_KCS — Sat, 30 Nov 2013 16:06:52 GMT

Hi Jaswant,

thanks for reply, i am new to QLIKVIEW

but i want create TimeDimension (this is my date field SAMPLE_MONTH)

i want to create a starschema model

Re: link table

Anonymous — Sat, 30 Nov 2013 20:16:23 GMT

If you are familiar with SUB functions you can CALL the Link table SUB that is included in this script library below.

qlikview-components - A script library for Qlikview development - Google Project Hosting

Re: link table

Nagaraju_KCS — Mon, 02 Dec 2013 05:05:13 GMT

Hi All,

I am confusing with LINK TABLE ,,

please any one can help me..

Re: Re: link table

tresB — Mon, 02 Dec 2013 05:22:14 GMT

If you really want to learm and implement then please refer the attachment. Otherwise, if you are thinking of getting rid of your present model, I would give you one(there could be more) hint of issue area rather than going through the entire model of yours and correct it. Your LinkTableTemp and the LinkTable are having same fields and getting autoconcatenated. Hence, when you drop the temp file the link table is getting dropped with the temp file.

Re: link table

Nagaraju_KCS — Mon, 02 Dec 2013 05:37:57 GMT

Hi Tresesco,

thanks for quick response..

Here i concatenate BRANCH &'-'& SERVICE_CENTER &'-'& SAMPLE_MONTH as Key

SAMPLE_MONTH is my date field,

i want to create a Year and Month

Re: link table

Anonymous — Mon, 02 Dec 2013 11:57:56 GMT

Hi,

Could you test if this is what you want :

=Year(C_SAMPLE_MONTH)

=Month(C_SAMPLE_MONTH)

You can puth it in the load-script or in any expression.

Paul

Re: link table

Nagaraju_KCS — Mon, 02 Dec 2013 12:53:50 GMT

Hi Tresesco,

is it possible to create StarSchema....

Re: link table

tresB — Mon, 02 Dec 2013 13:10:31 GMT

Community might not be right place to have a look at your data model and correct it in entirety. Still, here is something I found (not sure if right wrt your requirement) that you can try with. If all BRANCH, SERVICE_CENTER and SAMPLE_MONTH and FILE_NO are common across tables, simply load them concatenat. For rest of your model, I see FILE_NO is the KEY, therefore the model would be ready with the common link key FILE_NO.

Re: link table

Anonymous — Mon, 02 Dec 2013 14:52:02 GMT

You cannot use the same common fields in more than two tables to create a model because Synthetic key will happen. but you can make different key fields by combining different fields and these fields should be common in names with the link table to create a star schema model. For example, in the first table use Sample_Month as the key. In the second table use Service_center, in the third table use Branch, and in the fourth table use combined key Branch & Service_Center Etc.

I hope this helps.

Walid