Knowledge Base / Designer / GCSE-544: Error: "The field "XXX" was renamed conflicting with an existing field name"
Summary
Environment
Environment Details
Alteryx Designer
- Versions 2021.2–2022.1
Overview
Fields within the configuration window of the Select Tool functionality are duplicated and reported as (Missing). The following error is returned by the Select Tool, preventing downstream processing.
The field "XXX" was renamed conflicting with an existing field name
Additional tools that include the Select Tool Functionality:
- Append Fields
- Find Nearest
- Join
- Join Multiple
- Select In-DB
- Spatial Match
Cause
Cause
Updates to the case type of fields are not being processed appropriately within existing Select Tool functionality configurations.
Resolution
Workarounds
Because the behavior is present in many tools, and each person's workflow is different, some of these workarounds may or may not work for you.
- Within the tool configuration for the Select functionality, click Options > Forget All Missing Fields. This option should work if you have the *Unknown option checked.
- Avoid clicking on the tool in question - only clicking on the tool will cause this issue. If you are using a Select tool, simply placing another Select tool upstream, and instead configuring that Select tool can help.
- Add a Dynamic Rename tool after the tool that reads in data from the data source. In the Dynamic Rename tool, use a formula in the Expression editor to set the letter case of the field names.
