topic Re: Scenario Help in QlikView https://community.qlik.com/t5/QlikView/Scenario-Help/m-p/878702#M995092 <HTML><HEAD></HEAD><BODY><P>Just load everything. An Excel data source (especially when talking about a single file) on average doesn't carry &gt;1 million records. Moreover, reading files is less costly than reading through a network pipe.</P><P></P><P>Did you time your script as it is reading the entire file? Does it take more than 5-10 minutes?</P><P></P><P>Peter</P></BODY></HTML> Fri, 03 Jul 2015 10:29:18 GMT Peter_Cammaert 2015-07-03T10:29:18Z Scenario Help https://community.qlik.com/t5/QlikView/Scenario-Help/m-p/878701#M995091 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P></P><P>I have Data source in Excel Form, which is placed at FTP.. Now on daily basis these excel reports are updating..</P><P></P><P>Scenario1- Some times Whole 2 year data is Replaced</P><P>Scenario2- Out of two Year only one year data is replaced.</P><P>Scenario3 - Out of two year only 3 month Data is replaced.</P><P></P><P>In All three Scenario new Data will Append into Excel.</P><P></P><P>In Scenario1 - I only required to Reload my application and all data will come..</P><P>But in Scenario 2 and Scenario 3 How i can do automated Data reload??</P><P></P><P>Thanks in Advance</P><P></P><P>Abhay</P></BODY></HTML> Fri, 03 Jul 2015 10:10:48 GMT https://community.qlik.com/t5/QlikView/Scenario-Help/m-p/878701#M995091 abhaysingh 2015-07-03T10:10:48Z Re: Scenario Help https://community.qlik.com/t5/QlikView/Scenario-Help/m-p/878702#M995092 <HTML><HEAD></HEAD><BODY><P>Just load everything. An Excel data source (especially when talking about a single file) on average doesn't carry &gt;1 million records. Moreover, reading files is less costly than reading through a network pipe.</P><P></P><P>Did you time your script as it is reading the entire file? Does it take more than 5-10 minutes?</P><P></P><P>Peter</P></BODY></HTML> Fri, 03 Jul 2015 10:29:18 GMT https://community.qlik.com/t5/QlikView/Scenario-Help/m-p/878702#M995092 Peter_Cammaert 2015-07-03T10:29:18Z