Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have to load the data from excel source on a monthly basis to the qlikview server .
What is the correct procedure to follow. If any one has code that will be greatly appreciated.
I am thinking ,incremental load to carry this task. But my manager asked me to do Full load monthly.
Can anyone correct my thinking pls and suggest the right way to do it.
Regards,
Vamsi.
Develop a qvw application with source file path then schedule it in server for every month.the full load will happen every month.
or else create a .bat file and schedule it for every month.
what it means u said ur manager asked to do full load monthly
monthly once u need full reload ? or dialy?
An incremental load from excel is pretty much impossible if you only got one excel that is updated on a monthly basis. Do you have a monthly excel at your disposal?
Well,the data will update monthly at source so What i am doing is creating QVD from that source and set a variable path to read from that source every month .Is my thinking correct to update the data at dashboard according to the update wherther it is weekly or monthly.
I dont think incrementa load is required because ur going to reload monthly once then go for manual load