Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
subash29
Contributor III
Contributor III
‎2018-03-21 12:36 PM

Associations vs Concatenate Tables

Hi Team,

We have to check Performance the which way is provide better solution on Associations vs Concatenate Tables in QlikSense ?

I have two set of tables which contain more than 500 columns in each table.I have created the link key for common fields and created the  link Table (contains 200 common fields).we are getting the correct data now.It definitely have the association key Weight age.

If i concatenate the those two tables without link table(not creating Associations key).How the data will perform?

Thanks

910 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2018-03-21 01:20 PM

500 columns is quite a lot, indeed it would take awful lot of viz's to exploit that many.  Are there any columns not used  that you could get rid of ?

A link table with 200 common fields seems very excessive.

p.s. I am advocate of concatenating fact tables where appropriate.

851 Views
0 Likes