nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Join tables

Filipbombeke

I want to join to two tables by matching columns (timestamp) with include non-matches for the onepager_HPPO table. The data from second table onepager HPPO_adddata_ONSTS is only present until 08/08/08 10:00 in the joined tables although it should be until end of 2019. The format of two timestamps is identical. What cause this issue or how can it be resolved?

ONEPAGER HPPO_adddata_ONSTS.jmp

ONEPAGER HPPO1.jmp

Accepted answers

txnelson

The issue is, that in data table ONEPAGER HIPPO_adddata_ONSTS, on 08/08/2018 at 11AM the input data changes. At 10AM the value is

08/08/2018 10:00:00.000 AM

at 11AM it changes to

08/08/2018 10:59:59.999 AM

If you run a little script that rounds all of the values to whole numbers, and then join the data, that should fix the issue.

All comments

Thierry_S

Hi Filip,

It looks like there might be a bug: I did reproduce your problem even when I forced the date stamp to be in numerical format. The only work around I could find, which is rather ugly, is to extract the HOUR, DAY, MONTH, and YEAR in separate columns for each table and joined based on all 4 values.
Maybe somebody else will have more insight.
Best,
TS

txnelson

The issue is, that in data table ONEPAGER HIPPO_adddata_ONSTS, on 08/08/2018 at 11AM the input data changes. At 10AM the value is

08/08/2018 10:00:00.000 AM

at 11AM it changes to

08/08/2018 10:59:59.999 AM

If you run a little script that rounds all of the values to whole numbers, and then join the data, that should fix the issue.

Filipbombeke

Indeed - I did not noticed this. Rounding the timestamps solved the issue. Thanks!