PROBLEMA

A ligação de dois campos não retorna nenhum valor correspondente no ArcGIS Pro

Last Published: December 6, 2024

Descrição

In ArcGIS Pro, when attempting to join two common fields from different tables using the Add Join tool, no matching values are returned in the joined table.

The joined table is from Day 1 and Day 1_CSV layers. The two common fields in the joined table are altitudes and altitude where no matching values are returned in the table. The data type of altitudes is Float.

Causa

The data types of the common fields do not match.

Solução ou Solução Provisória

The data types of the common fields must be the same to join a layer to another layer or table in ArcGIS Pro. For example, a float field cannot be joined with a double field as the data types of the fields are different. Refer to ArcGIS Pro: Join the attributes from a table for more information.

To resolve this issue, change one of the field data types to the same data type as the other common field by creating a new field in the layer’s attribute table, and use the Calculate Field tool to populate the values of the new field. Refer to How To: Change the data type of an existing field in ArcGIS Pro for instructions.

The image below shows matching values are returned in the joined table when joining two common fields with the same data type in ArcGIS Pro.

The joined table is from Day 1 and Day 1_CSV layers. The two common fields in the joined table are altitude and altitude where matching values are returned in the table. The data type of altitude is changed to Double.

ID do Artigo: 000025381

Receba notificações e encontre soluções para problemas novos ou comuns

Obtenha respostas resumidas e soluções de vídeo do nosso novo chatbot de IA.

Baixe o Aplicativo de Suporte da Esri

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download