I have a huge feature table with several hundreds of miles records of GPS positions.
Every feature has X,Y, device number, and driver name.
Id is a small integer, while the driver name is quite large text.
The more logical approximation is to store id in the main feature layer and the names in a related table.
I don't find a good way to do it. I try to do it making a relate on arcgispro and uploading it to arcgisonline, but I need the name being available to make a filter into a experienced builder filter widget and this way is not available.
Could you help me with any idea.
For info on publishing related tables from ArcGIS Pro, see these 2 links:
For info on joining tables in ArcGIS Online see these two links:
Note that the last link says that you need to use Map Viewer Classic for the join functionality.
Thanks for the info !
I can't use Arcgisonline map view joins because the point layer is updated every five minutes and I want to make the join permanent. Another issue is the credit consumption, the layer will be near 1 million points and the cost is huge.
I tried to publish the layer with the relate defined in desktop. It works and I can see the related attributes in the popup, but I need the name of the device that can be used to filter data in a dashboard and view it in tables. The related fields are not available for this kind of visualizations.
The solution should be making a view of the layer getting the related fields from another table or something like that.