This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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:
Updates to the case type of fields are not being processed appropriately within existing Select Tool functionality configurations.
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.