Message
ADP_102082: The following fields from the input dataset cannot be appended to the specified layer due to a field type mismatch: <fields>
Description
Feature layers can only be updated with datasets containing the same schema, or a compatible schema. For example, you cannot append string values to a field of type double. However, you can append integer values to a field of type double.
Solution
To resolve this issue, consider the following scenarios and solutions:
- If the input dataset is a CSV or delimited file, the schema that is inferred from the data may change each run. For example, if the delimited file initially contains a field with double values, the field will be inferred as a double and written to a feature layer as a double on the first run. If the delimited file is updated and the field now contains all empty values, the field will be inferred as a string and Data Pipelines will try to append string values to a field of type double and will fail. In this scenario, consider using the Fields parameter in the input tool to configure a schema that will be applied to the file for all runs to ensure your schema stays consistent.
- If you need to modify a field type and the input dataset is not a CSV or delimited file, consider using the following tools to update field types as needed:
- Update fields—Use this tool to update one or multiple field types.
- Map fields—Use this tool to map the fields from one dataset to the fields of another dataset. For example, you can map a dataset to the feature layer you want to update. This will update field names and types.
- Calculate field—Use this tool to leverage Arcade functions if your data values require more processing to get into the required field type.
Once the schema of the input dataset matches the layer to update, run the data pipeline again.