topic concatenate in QlikView https://community.qlik.com/t5/QlikView/concatenate/m-p/21691#M3616 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P>i have about 10 FACT tables i want to concatenate in a model.</P><P>3 of the <SPAN style="font-size: 13.3333px;">FACT contain 10 million rows each , i load them first and it takes about 2-3 minutes each.</SPAN></P><P><SPAN style="font-size: 13.3333px;">the other facts i'm loading contains 4-5 thousand rows each and they take about 20-30 minutes each.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">is there a way to reduce the small tables load time?<BR /></SPAN></P><P>of course not all the fields in the tables are in common .</P><P></P><P>advanced thanks</P></BODY></HTML> Tue, 30 Jan 2018 11:48:54 GMT ilanbaruch 2018-01-30T11:48:54Z concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/21691#M3616 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P>i have about 10 FACT tables i want to concatenate in a model.</P><P>3 of the <SPAN style="font-size: 13.3333px;">FACT contain 10 million rows each , i load them first and it takes about 2-3 minutes each.</SPAN></P><P><SPAN style="font-size: 13.3333px;">the other facts i'm loading contains 4-5 thousand rows each and they take about 20-30 minutes each.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">is there a way to reduce the small tables load time?<BR /></SPAN></P><P>of course not all the fields in the tables are in common .</P><P></P><P>advanced thanks</P></BODY></HTML> Tue, 30 Jan 2018 11:48:54 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/21691#M3616 ilanbaruch 2018-01-30T11:48:54Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/21692#M3617 <HTML><HEAD></HEAD><BODY><P>Not sure if this is possible.. </P></BODY></HTML> Tue, 30 Jan 2018 11:55:18 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/21692#M3617 evan_kurowski 2018-01-30T11:55:18Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/21693#M3618 <HTML><HEAD></HEAD><BODY><P>without knowing the field names its very hard to answer these question.</P><P></P><P>Please share some sample data to suggest a better data model</P></BODY></HTML> Tue, 30 Jan 2018 11:59:31 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/21693#M3618 techvarun 2018-01-30T11:59:31Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/21694#M3619 <HTML><HEAD></HEAD><BODY><P>Few questions?</P><P></P><P>1) Are you doing a group by on the smaller tables?</P><P>2) Are you loading the data from QVD Files or anther source?</P></BODY></HTML> Tue, 30 Jan 2018 12:50:19 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/21694#M3619 sunny_talwar 2018-01-30T12:50:19Z