topic Re: Timestamp to number in QlikView

Timestamp to number

alec1982 — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

I am trying to load a set of files and then use incremental load to only load new files.

the first step I am trying to take is to load the file modified timestamp and transform it to number then use that number on the incremental load.

the issue is the logic I use doesn't return any number.

Here is my logic. Can someone please help me fix it and thank you in advance.

num(Date(DATE#(filetime(),'MM/DD/YYYY h:mm:ss TT'),'MM/DD/YYYY')) asTimeStampNum

Alec

Re: Timestamp to number

engishfaque — Tue, 12 Apr 2016 03:40:07 GMT

Dear Alec1982,

Your given script for create new field "TimeStampNum" is working fine for me.

Can you share your sample App?

Kind regards,

Ishfaque Ahmed

Re: Timestamp to number

Anonymous — Tue, 12 Apr 2016 03:42:06 GMT

Hi Alec,

What is the issue?

Re: Timestamp to number

Anonymous — Tue, 12 Apr 2016 03:44:22 GMT

Hi Alec,

Give space after 'AS' . Its working for me

num(Date(DATE#(filetime(),'MM/DD/YYYY h:mm:ss TT'),'MM/DD/YYYY')) as TimeStampNum

Hope it helps!!

Re: Timestamp to number

tamilarasu — Tue, 12 Apr 2016 03:46:09 GMT

Try,

Load *,

Num(Floor(Filetime(DocumentPath()))) as TimeStampNum

From Source;

Re: Timestamp to number

alec1982 — Tue, 12 Apr 2016 03:57:20 GMT

hi Tamil,

this solution gives only the date number while I need the full timestamp number.

Re: Timestamp to number

alec1982 — Tue, 12 Apr 2016 04:04:41 GMT

this gives me for example 42454,251875 for the time stamp 3/25/2016 6:02:42 am which I believe it is wrong..

Re: Timestamp to number

alec1982 — Tue, 12 Apr 2016 04:04:59 GMT

this gives me for example 42454,251875 for the time stamp 3/25/2016 6:02:42 am which I believe it is wrong..

Re: Timestamp to number

alec1982 — Tue, 12 Apr 2016 04:05:17 GMT

this gives me for example 42454,251875 for the time stamp 3/25/2016 6:02:42 am which I believe it is wrong..

Re: Timestamp to number

alec1982 — Tue, 12 Apr 2016 04:13:11 GMT

thank you Tamil. I get 42471,998385064 for 3/25/2016 6:02:42 am.. How do I test if this value is correct..

Re: Timestamp to number

engishfaque — Tue, 12 Apr 2016 04:14:55 GMT

Dear Alec1982,

This is coming to you due to using Function "Num", Num function is converting your date into numbers.

Just remove your Num function and check your result.

Kind regrads,

Ishfaque Ahmed

Re: Timestamp to number

alec1982 — Tue, 12 Apr 2016 04:19:24 GMT

Ishfaque,

thank you for the help. I do need a number as my end result. my concern is that the number I get is not accurate.. and if you believe it is accurate, do you have any method to test it and confirm.

Thanks again..

Re: Timestamp to number

tamilarasu — Tue, 12 Apr 2016 04:25:47 GMT

Alec,

You can use the below function in textbox to test the result.

=Timestamp('42471,998385064')

The below script working fine in my system. Check the attachment.

Load *,

Num(DATE#(Filetime(),'MM/DD/YYYY h:mm:ss TT')) as TimeStamp

From Source;

Re: Timestamp to number

Anonymous — Tue, 12 Apr 2016 04:26:34 GMT

Hi,

Test like this

=Timestamp(42471.998385064)

It gives Date which should match with your date

Re: Timestamp to number

Anonymous — Tue, 12 Apr 2016 04:29:24 GMT

You can test in Text box

Re: Timestamp to number

alec1982 — Tue, 12 Apr 2016 04:35:03 GMT

well.. it doesn't match. I looked at the file and the time stamp on it shows 3/25/2016 6:02:42 am.

Re: Timestamp to number

alec1982 — Tue, 12 Apr 2016 04:38:55 GMT

this worked for me.. I think I had the remove the extra date#

Re: Timestamp to number

engishfaque — Tue, 12 Apr 2016 04:39:17 GMT

Dear Alec,

Kindly find attache app.

Kind regards,

Ishfaque Ahmed

Re: Timestamp to number

Anonymous — Tue, 12 Apr 2016 04:40:26 GMT

Check this in text box

=Timestamp(42454.251875)

Hope it helps!!

Re: Timestamp to number

tamilarasu — Tue, 12 Apr 2016 04:46:19 GMT

Alec, Your first syntax also working fine. I guess, you forgot to add space between alias name as already mentioned by Anil. Have a look at the attached file.