Issue
After connecting to a SAS file, changes to the metadata of that file will result in an error:InsertData: Multiple entries for column [COLUMN_NAME]
Additionally:
New connections to the same file in the same workbook are also affected.
Last Modified Date: 15 Feb 2017
InsertData: Multiple entries for column [COLUMN_NAME]
Additionally:
New connections to the same file in the same workbook are also affected.
Environment
- Tableau Desktop 9.3.0-9.3.9, 10.0.0-10.0.3, 10.1.0-10.1.1
- SAS file
Resolution
Option 1:
Upgrade to Tableau Desktop 9.3.11, 10.0.5, 10.1.3 or a newer version. For more information, see Upgrade Tableau Desktop.Option 2:
If you are unable to upgrade, or if the error does not resolve after upgrading,- Rename the SAS file
- Re-connect to the file
- Replace the old data source with the new file using Data > Replace Data Source.
Cause
This behavior is related to a known issue, ID 574013, which has been resolved in a later version.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials