This article details steps to resolve "Invalid Query [QueryName] :The target name [TargetName] is duplicated" in Statistica Enterprise Manager? This error occurs usually when a new data configuration is being saved in Statistica Enterprise with duplicate column/variable names.

How to resolve "Invalid Query [QueryName] :The target name [TargetName] is duplicated" in Statistica Enterprise Manager?

This error indicates that there are two columns that have the same name in the query defined. This is mostly because of a join in the query pulling fields from 2 or more tables. If you click on the plus next to the data configuration where this error is seen, it will show all the fields from the query.  The target name is likely repeated twice if you are seeing this error on clicking on Commit while saving a newly defined data configuration.



To resolve the error, click on the field name and change the target name as shown below.



NOTE: Changing the Target Name in the Enterprise Manager will not change anything in the original table of the database. The Target name can be considered equivalent to an alias in SQL statements.  The goal of the target name change is to ensure Statistica has unique variable names while retrieving the data into a spreadsheet and performing analysis.