Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

chooco_co
Valued Contributor

Use Concatenate or Link Table?

hi,

error loading image

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

thanks,

1 Solution

Accepted Solutions
sunil2288
Contributor III

Use Concatenate or Link Table?

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

11 Replies
sunil2288
Contributor III

Use Concatenate or Link Table?

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

chooco_co
Valued Contributor

Use Concatenate or Link Table?

thanks for your quick reply,

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

chooco_co
Valued Contributor

Use Concatenate or Link Table?

hi sunil,

it's better doing join table not Concatenation,

thanks

sunil2288
Contributor III

Use Concatenate or Link Table?

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

sunil2288
Contributor III

Use Concatenate or Link Table?

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

chooco_co
Valued Contributor

Use Concatenate or Link Table?

hi sunil

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

qliksus
Valued Contributor

Use Concatenate or Link Table?

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.

sunil2288
Contributor III

Use Concatenate or Link Table?

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

qliksus
Valued Contributor

Use Concatenate or Link Table?

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.