AnsweredAssumed Answered

Join table to feature layer with multiple records per feature

Question asked by LawMatthew on Feb 29, 2020
Latest reply on Apr 2, 2020 by xzy72_pennstate

I am trying to visualise temporal data following this tutorial (but using my own data). I have a standalone table with the data in at different times for each feature, in a similar fashion to below (ie multiple entries for the values for each building at different times).

 

buildingtimecount
library22/11/2018 00:20:001
house22/11/2018 00:20:002
school22/11/2018 00:20:002
library22/11/2018 00:40:003
house22/11/2018 00:40:002
school22/11/2018 00:40:004
library22/11/2018 00:60:003
house22/11/2018 00:60:005
school22/11/2018 00:60:006

 

The standalone data table has 3,096 rows, showing the values for 43 buildings at 72 different times. The spatial data, to which I am trying to join the table, has 199 buildings (43 of which I have data for in the standalone table).

 

When I try to join the table to the layer, following the tutorial, the result only keeps the first instance of each building, ie the number of records in the layer's attribute table doesn't increase to include the values for each building at each point in time (as in the tutorial), but instead stays at 199 and only joins the values for the earliest time (thus making it impossible to visualise the data across time). Attached is a screenshot of the settings I have for the join – I've replicated those in the tutorial video but seem to have got a different result.

Where am I going wrong?

Attachments

Outcomes