AnsweredAssumed Answered

Can you use a 1:n relate or join for time-enabled layers?

Question asked by raze on May 1, 2018
Latest reply on May 1, 2018 by Dan_Patterson

I have a simple point layer with pointIDs, and a standalone table with time values and pointIDs. The time values are in hourly intervals (start+end times over a single day). The pointIDs repeat in the time table, so there are 24 entries per pointID.

 

When I do a relate, the time option doesn't recognize any field. When I do a join, only one row from the table is used. I faintly remember being able to export a 1:n join to end up with a feature containing duplicate points or each join, but I can't replicate it.

 

As a workaround I extracted and joined the XYZ coordinates of the points in Excel and created a layer for that but that's pretty convoluted..

Outcomes