Error: A column already belongs to this DataTable

Products

• Information Centric Analytics

Issue/Introduction

The following error is displayed when testing a data source query against a CSV or XLSX file in the Integration Wizard (IW):

Error: A column named '<column-name>' already belongs to this DataTable.

Error ID: <ID>

The same error is logged in the RiskFabric server log with the exception details and stack trace. This log is located on the application server in the following default path:

%SystemDrive%\ProgramData\BayDynamics\Logs\w3wp_RiskFabric.<yyyyMMdd>.log

Cause

The source file used as the data source contains two or more identically named columns.

Resolution

Ensure all column names in the source file are distinct.