Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to upload excel file on a daily basis from a cloud platform to QlikView file, at a specified time interval? If so, can you please help me with the procedure?
Hi, this is possible
you will have to create a qvw document that will be responsable to acces to the cloud and load the excel and you can store as a qvd after that.
in the qmc(management console) you will have the possibility to put the interval time that you want to this document qvw run, for example you could put to reload every day at five oclock(or the time you want).
then you will use this qvd and load in the finish document, the document that will see the user, will use the qvd that you generate after.
hope helps,
Fernando
Hi Fernando,
Thanks for your response. Will it be the same procedure, if there is a new excel file uploaded on cloud daily? I mean, there will be new file uploaded daily, and the application needs to recognize the new file and upload it (for example, the file name for current day would be 'Internal Call Analysis_Feb 16, 2015' and tomorrow's file name would be ''Internal Call Analysis_Feb 17, 2015') with totally new records.
Regards,
Jagan
Hi Jagannadha
it is the same because you can not put all the name of the file , only the part of the file name that stand always
for example
when you will try to acces to get the excel(load excel in qlikview) would be like this
load *
from Internal Call Analysis_*.txt
the * in the name of the excel suggest that will load although the variable name of the excel.
one question, every day is one diferent and change the date
you can do it without problem
Fernando
Hi,
You have to extract Day and year part from current date of Qlik View server while loading the excel file and concatenate it with file name.
ex.:'Internal Call Analysis_Feb '&date(now(),'d')&', '&date(now(),'yyyy')
As long as the structure of the name and the the content are consistent would it be no problem at all.
yep, there wont be any problem if the structure and name are consistent.