Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Creator III
Creator III

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

View solution in original post

11 Replies
Highlighted
Creator III
Creator III

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

View solution in original post

Highlighted
Partner
Partner

thanks for your quick reply,

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

Highlighted
Partner
Partner

hi sunil,

it's better doing join table not Concatenation,

thanks

Highlighted
Creator III
Creator III

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

Highlighted
Creator III
Creator III

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

Highlighted
Partner
Partner

hi sunil

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

Highlighted
Specialist II
Specialist II

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.

Highlighted
Creator III
Creator III

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

Highlighted
Specialist II
Specialist II

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.