topic Re: How to use TimeStamp in key in QlikView

How to use TimeStamp in key

Anonymous — Fri, 28 Apr 2017 11:25:07 GMT

All I am facing an issue while creating a key with ID and timestamp

I created the composite key using ID &'_'& floor(LastTimeStamp) as key

floor(LastTimeStamp) give the same result for both the LastTimeStamp i.e. 42537.

Any help ,how we can implement this

load * Inline [

ID, LastTimeStamp

R1, 16/06/2016 14:13:02

R2,16/06/2016 14:13:28

];

Re: How to use TimeStamp in key

sunny_talwar — Fri, 28 Apr 2017 11:29:41 GMT

May be try this

LOAD *,

ID & ' - ' & Floor(LastTimeStamp*86400) as Key;

load * Inline [

ID, LastTimeStamp

R1, 16/06/2016 14:13:02

R2, 16/06/2016 14:13:28

];

Re: How to use TimeStamp in key

stabben23 — Fri, 28 Apr 2017 11:30:57 GMT

Hi,

what format has the other Datefield which you want to "join" With?

If that also is timestamp then dont use floor to get a uniqe key.

Re: How to use TimeStamp in key

Anonymous — Fri, 28 Apr 2017 12:45:04 GMT

Same format

Re: How to use TimeStamp in key

Anonymous — Fri, 28 Apr 2017 12:45:58 GMT

Y u have multiply with this no. What it will do .can u explain

Re: How to use TimeStamp in key

sunny_talwar — Fri, 28 Apr 2017 12:48:46 GMT

I am converting the whole timestamp into seconds by multiplying it by 24 * 60 * 60 and unless there are two timestamps which matches to the last second, you will get a distinct key

Re: How to use TimeStamp in key

PrashantSangle — Fri, 28 Apr 2017 12:56:52 GMT

Hi,

just one query why convert it into floor????

just use. if you want to remove . from it use replace() for it.

1: ID &'_'& num(LastTimeStamp)

ID &'_'& replace(num(LastTimeStamp),'.','')

Regards,