Arcgis online Table to point feature on map

[HingFungChan]

Hi,
I just made a table combined the WeatherStation, Real-time Temperature, and their coordinate with Data Pipeline. It's a joined feature.
So now I have a table linked below:

https://services8.arcgis.com/HFMAqSZEptBjhiQv/arcgis/rest/services/Refresh_Join_1304/FeatureServer

I want to show these data on map. But I have problem converting it to layer.
I tried to use "Add Layer" by URL and select CSV in Type. But it can only the fields.
Please help🙏

[EmilyGeo]

Hi @HingFungChan, 

It looks like the output that you created is a table. Tables only contain attributes (fields), and do not contain any geometry. 

One option for working with this table is to upload the CSV file as a "New item" in My Content and specify the X and Y fields containing the coordinates, then publish that as a hosted feature layer.

However, keep in mind if you prefer to create layer outputs in your data pipeline, you can do that using the Output tool. That way you will have a layer that stores geospatial information in addition to the attributes:

Hope that helps! Emily

[HingFungChan]

Thank you so much for your reply.
Publish the Data as a hosted feature layer does not work for me, since the data I need is a real time temperature from a CSV URL, but this data does not contain geometry columns.
That's why I need to do the join feature in Data Pipeline. To join with a CSV file with geometry columns.
If I download the table and upload it to layer, it's fine except it will lose the auto-refresh function.
Is there a way to export the table as a csv URL?

[EmilyGeo · Accepted solution]

One option would be to add a layer with location data to the join if you have one available.

Another option would be to try the Create geometry tool 

[HingFungChan]

Thx so much for your answer, I have been stuck in this problem for weeks. Truly appreciate it.