Virtual Join

SymS — Sat, 10 Jun 2023 23:32:10 GMT

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.

Re: Virtual Join

jthi — Tue, 22 Jun 2021 05:10:33 GMT

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));

topic Virtual Join in Discussions

Virtual Join

Re: Virtual Join