HOW TO

Join hosted feature layers and extract features to Excel in ArcGIS Data Pipelines

Last Published: October 8, 2024

Summary

In ArcGIS Data Pipelines, hosted feature layers can be joined to integrate attributes from multiple datasets based on spatial or attribute relationships. This layer can be subsequently filtered to create a new hosted feature layer, which can be visualized and analyzed within ArcGIS products. This method allows the hosted feature layer to be exported to an Excel file, which enhances its accessibility and ensures efficient data retention from various sources. This article provides the workflow to join and extract features from a hosted feature layer based on field values to an Excel file in ArcGIS Data Pipelines.

Procedure

In this example, the counties with the highest disease infection rates are identified and exported to the Excel file.

Note:
ArcGIS Data Pipelines consumes credits when the compute resource is active. Refer to ArcGIS Data Pipelines: Credit consumption for more information.
  1. Log in to ArcGIS Online with an organizational account.
  2. Click Apps The Apps button and click Data Pipelines.
  3. On the Data Pipelines gallery page, click Create data pipeline.
  4. On the data pipeline editor, add the hosted feature layer from My content to the canvas.
    1. On the editor toolbar, click Inputs > Feature layer.
    2. In the Select a feature layer window, click the preferred hosted feature layer and select the feature layer from the Select layer drop-down list. In this example, the feature layer named County is selected. Click Add.
  5. Repeat Step 4 to add another hosted feature layer to the canvas.
  6. Join the added feature layers based on the common attribute field using the Join tool.
    1. On the editor toolbar, click Tools > Join.
    2. In the Join panel, for Target dataset, click Dataset and select the feature layer to be appended with fields from the join dataset. In this example, the feature layer named County_C is selected.
    3. For Join dataset, click Dataset and select the feature layer containing the field to be appended to the target dataset. In this example, the feature layer named County is selected.
    4. For Join operation, select the preferred join option from the drop-down list. In this example, Join one to one is selected.
    5. For Attribute relationship, toggle Use matching fields on.
    6. For Target field, select the common attribute field to be used from the target dataset.
    7. For Join field, select the common attribute field to be used from the join dataset.
    8. Click Preview.
The Join panel
  1. Extract the features from the joined feature layer based on the preferred field values using the Filter by attribute tool.
    1. On the editor toolbar, click Tools > Filter by attribute.
    2. In the Filter by attribute panel, for Input dataset, click Dataset and select the join dataset in Step 6.
    3. For Filter expression, click Build new query.
    4. In the Query builder dialog box, select Expression and click Next.
    5. Enter the following query expressions to specify the features to be extracted as a new hosted feature layer. In this example, the frequency field is selected with the field value high, which indicates the highest disease infection rates for each county.
Where All of the following are true <field> equals <field value>
    1. Click Expression to add another query expression, if necessary.
    2. Click Add > Preview.
    1. Export the filtered dataset as a hosted feature layer to ArcGIS Online.
      1. On the editor toolbar, click Outputs > Feature layer. The Feature layer element is added to the canvas.
      2. Click and drag the pointer from the output port of the Filter by attribute element to the input port of the Feature layer element.
      3. In the Feature layer panel, for Output method, select Create.
      4. For Output name, specify a name for the output feature layer.
      5. For Folder, specify a location to save the output feature layer from the drop-down list. Click Preview.
      6. On the action bar at the top of the canvas, click Run.
    The data pipelines on the canvas
    1. Export the data from the hosted feature layer to the Excel file. Refer to ArcGIS Online: Export data from hosted feature layers for instructions.

    Article ID: 000033684

    Software:
    • ArcGIS Online

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options