topic Regarding Reloading of Data???? in QlikView https://community.qlik.com/t5/QlikView/Regarding-Reloading-of-Data/m-p/237026#M88136 <HTML><HEAD></HEAD><BODY><P>Hi All..</P><P>i have 6 tables.. 5 dimension table and 1 fact table.. In fact table there is huge data like for 1 hour the data in fact table is 13 million rows..</P><P>My query is....how can we make our loading such that the dimension table will be loaded for one time and i can reload (schedule) the fact table with reloading the dimension tables again and again....</P><P>Dimensions: Time, location, station, product design, operations</P><P>Fact: MFG</P><P>Thanks in advance</P></BODY></HTML> Mon, 02 May 2011 11:22:25 GMT sushil353 2011-05-02T11:22:25Z Regarding Reloading of Data???? https://community.qlik.com/t5/QlikView/Regarding-Reloading-of-Data/m-p/237026#M88136 <HTML><HEAD></HEAD><BODY><P>Hi All..</P><P>i have 6 tables.. 5 dimension table and 1 fact table.. In fact table there is huge data like for 1 hour the data in fact table is 13 million rows..</P><P>My query is....how can we make our loading such that the dimension table will be loaded for one time and i can reload (schedule) the fact table with reloading the dimension tables again and again....</P><P>Dimensions: Time, location, station, product design, operations</P><P>Fact: MFG</P><P>Thanks in advance</P></BODY></HTML> Mon, 02 May 2011 11:22:25 GMT https://community.qlik.com/t5/QlikView/Regarding-Reloading-of-Data/m-p/237026#M88136 sushil353 2011-05-02T11:22:25Z AW:Regarding Reloading of Data???? https://community.qlik.com/t5/QlikView/Regarding-Reloading-of-Data/m-p/237027#M88137 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can use partial reload, enter Replace or Add to Load-statement</P><P>Data1:<BR />Replace Load * Fraom Table1;</P><P>means, that the table is complete replaced</P><P>Data2:<BR />Add Load * from Table2 Where ...;</P><P>means, that the new data is added to existing table.</P></BODY></HTML> Mon, 02 May 2011 11:47:17 GMT https://community.qlik.com/t5/QlikView/Regarding-Reloading-of-Data/m-p/237027#M88137 brenner_martina 2011-05-02T11:47:17Z