topic Use Concatenate or Link Table? in QlikView

Use Concatenate or Link Table?

marcohadiyanto — Mon, 27 Dec 2010 04:38:32 GMT

hi,

i have this table viewer with sync Table and Loop, what should i do? use link table or concatenate?

thanks,

Use Concatenate or Link Table?

sunil2288 — Mon, 27 Dec 2010 05:05:45 GMT

Hi,

You better use join as Concatenation is permissible when two tables has same domain data.

here Insurrance Asset and prodcut offering are two different Entoty showing different data.

Regards

Sunil

Use Concatenate or Link Table?

marcohadiyanto — Mon, 27 Dec 2010 05:19:02 GMT

thanks for your quick reply,

so, what do you mean use join better than Concatenation?

Use Concatenate or Link Table?

marcohadiyanto — Mon, 27 Dec 2010 05:26:29 GMT

hi sunil,

it's better doing join table not Concatenation,

thanks

Use Concatenate or Link Table?

sunil2288 — Mon, 27 Dec 2010 05:37:42 GMT

HI,

Have you ever used Inner join Or Concatenation on two tables...

Joining of two tables is normal join as SQL.

But Concatenation means adding new data into an existing table...

Regards

Sunil

Use Concatenate or Link Table?

sunil2288 — Mon, 27 Dec 2010 05:37:57 GMT

HI,

Have you ever used Inner join Or Concatenation on two tables...

Joining of two tables is normal join as in SQL.

But Concatenation means adding new data into an existing table...

Regards

Sunil

Use Concatenate or Link Table?

marcohadiyanto — Mon, 27 Dec 2010 05:54:56 GMT

hi sunil

thanks for your reply . I'll check it first.

Use Concatenate or Link Table?

qliksus — Mon, 27 Dec 2010 06:10:24 GMT

Its always better to create a Linktable when you similar field in 2 or more table. Now you have to create a LinkTable which contain all similarfield name and key from the tables and make linking key from Linktable fields and join with the child table. All similar fieldname table should connect to Linktable not with eachother.

Use Concatenate or Link Table?

sunil2288 — Mon, 27 Dec 2010 06:34:42 GMT

Hi Susant Bhai..

How are you...M In mumbai now.

Will you please tell me Is Link table same as fact table in Datawarehousing..

Regards

Sunil

Use Concatenate or Link Table?

qliksus — Tue, 28 Dec 2010 07:23:30 GMT

No both are not same. fact table contains all Trancation details and from there link goes to dimension table. But Link table contains all similar field .

When u are working with Warehouse data (which contain dimension and fact) then linktable is same as CommonFact table.

Use Concatenate or Link Table?

marcohadiyanto — Wed, 29 Dec 2010 11:18:54 GMT

hi, thanks for your reply

i know concatenate table but to make link table, i don't know how.

any idea or example?

Marco

Use Concatenate or Link Table?

sunil2288 — Wed, 29 Dec 2010 12:05:29 GMT

Hi Macro,

If there are two tables having more than two fields common. Here we can make the two table single but sometimes it really worth to keep the two tables stand alone.

Like Let for a company there are two tables called

Service,Product

Here there is a situation of more than two fields common in both the tables. But it really worthy to keep both the table indivdually stand. To accomplish the lnik between the tables we should create a link table which contain the common fields of both the tables but not creating a synthetic table..

Here we should make the field name using some aliases. and keep the two tables linked .

As we are using the intermediate table for Linking .It is called link table...

Regards,

Sunil