topic Associations vs Concatenate Tables in App Development https://community.qlik.com/t5/App-Development/Associations-vs-Concatenate-Tables/m-p/66985#M4429 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>We have to check Performance the which way is provide better solution on Associations vs Concatenate Tables in QlikSense ?</P><P></P><P>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&nbsp; link Table (contains 200 common fields).we are getting the correct data now.It definitely have the association key Weight age.</P><P></P><P>If i concatenate the those two tables without link table(not creating <SPAN style="font-size: 13.3333px;">Associations </SPAN>key).How the data will perform?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 21 Mar 2018 16:36:22 GMT subash29 2018-03-21T16:36:22Z Associations vs Concatenate Tables https://community.qlik.com/t5/App-Development/Associations-vs-Concatenate-Tables/m-p/66985#M4429 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>We have to check Performance the which way is provide better solution on Associations vs Concatenate Tables in QlikSense ?</P><P></P><P>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&nbsp; link Table (contains 200 common fields).we are getting the correct data now.It definitely have the association key Weight age.</P><P></P><P>If i concatenate the those two tables without link table(not creating <SPAN style="font-size: 13.3333px;">Associations </SPAN>key).How the data will perform?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 21 Mar 2018 16:36:22 GMT https://community.qlik.com/t5/App-Development/Associations-vs-Concatenate-Tables/m-p/66985#M4429 subash29 2018-03-21T16:36:22Z Re: Associations vs Concatenate Tables https://community.qlik.com/t5/App-Development/Associations-vs-Concatenate-Tables/m-p/66986#M4430 <HTML><HEAD></HEAD><BODY><P>500 columns is quite a lot, indeed it would take awful lot of viz's to exploit that many.&nbsp; Are there any columns not used&nbsp; that you could get rid of ?</P><P></P><P>A link table with 200 common fields seems very excessive.</P><P></P><P>p.s. I am advocate of concatenating fact tables where appropriate.</P></BODY></HTML> Wed, 21 Mar 2018 17:20:44 GMT https://community.qlik.com/t5/App-Development/Associations-vs-Concatenate-Tables/m-p/66986#M4430 Anonymous 2018-03-21T17:20:44Z