How to use TimeStamp in key

[Anonymous]

Hi

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

];

[sunny_talwar]

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

];

[stabben23]

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.

[Anonymous]

Same format

[Anonymous]

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

[sunny_talwar]

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

[PrashantSangle]

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)

or

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

Regards,