Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

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?

6 Replies
fkeuroglian
Partner - Master
Partner - Master

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

Not applicable
Author

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

fkeuroglian
Partner - Master
Partner - Master

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

Anonymous
Not applicable
Author

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')

Not applicable
Author

As long as the structure of the name and the the content are consistent would it be no problem at all.

Anonymous
Not applicable
Author

yep, there wont be any problem if the structure and name are consistent.