Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marcohadiyanto
Partner - Specialist
Partner - Specialist

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
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
sunil2288
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

marcohadiyanto
Partner - Specialist
Partner - Specialist
Author

thanks for your quick reply,

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

marcohadiyanto
Partner - Specialist
Partner - Specialist
Author

hi sunil,

it's better doing join table not Concatenation,

thanks

sunil2288
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

sunil2288
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

marcohadiyanto
Partner - Specialist
Partner - Specialist
Author

hi sunil

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

qliksus
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.

sunil2288
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

qliksus
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.