Select first row as column names using Microsoft SharePoint File (custom connector)

[Holger Schimanski 2]

We have recently installed the Custom connector to load data from CSV or Excel files from Sharepoint online.

When connecting to a Excel file, I am missing the functionality to select the first row of the table as column names. Because of this my columns are called Col1, Col2, Col3.

Any idea We are using Spotfire 11.4 LTS.

[Holger Schimanski 2]

The solution is pretty simple and standard. Just choose "Name Row".