topic Time format excel from web. in QlikView

Time format excel from web.

Anonymous — Thu, 24 Nov 2016 13:59:43 GMT

Hi,

i have 2 excelfiles with values for 2014 and 2015.

Am trying to load the values for 2016 YTD from a web page so it will update automaticaly every day.

One problem;

Hours from excel file is the same as the one from the web page, but when i load it in my QV modell it says its different and duplicates.

Re: Time format excel from web.

kuczynska — Thu, 24 Nov 2016 14:38:55 GMT

Hi there,

It's very possible that when you are pulling the data from web page it stores is as time stamp (format HH:MM:SS) rather than HH:MM, which would explain why you're getting multiple results.

You should try to use FLOOR() function in load script.

Hope this helps.

Re: Time format excel from web.

Anonymous — Thu, 24 Nov 2016 14:52:50 GMT

Hi,

hmm. just a floor function wouldnt solve it..

here is a screen show from the excelfile:

Hours is 'hh-hh'

it is from hour 00 to hour 01

from 01 to 02

from 02 to 03

any suggestions?

Re: Time format excel from web.

kuczynska — Thu, 24 Nov 2016 15:44:25 GMT

So - 'Hours' comes as text from what I understand, yes? There must be a difference between the values excel. Is the len() of each entry the same then?

Let's not forget that if 'Date' comes as a timestamp from the web page it could add some extra granularity to extracted data. Check num(Date) too just to make sure this field doesn't require a trim.

Maybe just upload a sample qvw with few rows of data.

Re: Time format excel from web.

Anonymous — Thu, 24 Nov 2016 19:17:55 GMT

i think it comes as text, yes.