AnsweredAssumed Answered

Can two hosted layers be joined and republished as service?

Question asked by CESPEL@miamidade.gov_MDC on Mar 30, 2018
Latest reply on Apr 2, 2018 by KGerrow-esristaff

I have two workforce hosted layers that I need to join. Assignments layer has only workerID but no name. Worker layer has the name and the objectID is the workerID. So I connected to the layers in ArcMap and created a join to be able to show the name field. I tried publishing the MXD as a service, but I get the "SEVERITY STATUS CODE DESCRIPTION NAME TYPE DATA FRAME High Unresolved 00004 Layer's data source is not supported Assignments Layer Layers" error after analyzing. I tried converting the hosted layers to hosted views, but still got the same error. I then tried to publish the MXD as a service to my local server and still got the same error. 

If this is not possible, how can I join those two layers and post them so people can see the fields needed?

Mind you, this data is updated in real time. I cannot create a new layer because it has to show actualized data.