User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

  • JMP Security Notice: CVE-2026-109618 and CVE-2026-109619

    JMP promptly initiated a review of its products, services, and relevant infrastructure for exposure to CVE-2026-109618 and CVE-2026-109619.

    Our assessment of JMP products has not identified exposure to these vulnerabilities. Where remediation was required within supporting environments, appropriate security updates and controls have been applied and validated.

    We have identified no evidence of successful exploitation or unauthorized access to JMP systems or customer information associated with these vulnerabilities.

    JMP continues to monitor the issue and relevant vendor guidance. No action is required by JMP customers at this time.

  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
SymS
SymS
Level III

Virtual Join

Created: Jun 21, 2021 05:49 PM  |  Last Modified: Jun 10, 2023 4:32 PM (1508 views)

I am trying to connect multiple tables via Virtual Join for which Timestamp is the Reference key.

The main table has 2021-01-03 09:30:01 time stamp format where the column is nominal.

2 other tables which had the same "time stamp" format has been joined. I need to join the 4th and 5th Table with Time stamp in Numeric format as shown here 3/10/2021 16:45

Note- I do not have "second (from Timestamp) :01 or :02" in the 4th and 5th table.  I am not concerned about the" second (from Timestamp)" - if that helps. I tried parsing timestamp and use concatenate-- But that did not work.How to get this accomplished? Any help.

0 Kudos
1 REPLY 1
jthi
Super User jthi
Super User

Re: Virtual Join

Jun 22, 2021 01:10 AM (1495 views)  |  Posted in reply to message from SymS 06-21-2021

Have you tried removing second part of all timestamps? I think the timestamps will have to be exactly same. Easiest way to check if all have same values is to change the columns format to best / fixed dec to see date-time value. 

 

You can remove seconds for example by deducting Second(date) from the date you have. Example:

Names Default To Here(1);
curDate = Today();
show(curDate, as date(curDate));
curDateNoSeconds = curDate-Second(curDate);
Show(curDateNoSeconds, as date(curDateNoSeconds));

 

-Jarmo

Recommended Articles