Timestamp key not working

[alexandermllr]

Hello everyone,

I have two tables which are conneced by a timestamp key. Sometimes the data are not conneced and it will greate a second line in the table. The format in both tabels are the same.

Example:

Timestamp_Key	Data Table 1	Data Table 2
01.01.2020 00:30	25	-
01.01.2020 00:30	-	50

I hope someone can help me!

Thanks!

[QFabian]

Hi, maybe the timestamps looks alike, but can have minimal differences in milliseconds.

try apply ceil() or floor() to have the same numbers of decimals for each timestamp.

[alexandermllr]

Hi,

thank you, but I did not work.

I just used round(Timestamp_Key,0.01) and now it works.