Spotfire: Importing List from Sharepoint Online Connector results in multiple tables created

Problem:

It is possible that when importing a List from Sharepoint Online Connector into a Spotfire analysis, you will see multiple tables created, rather than the expected data table with a record-for-record match.

If you see this happens, it is likely that within Sharepoint Online some columns in your list have a feature enabled called 'Allow multiple selections'. What this means is that Sharepoint Online allows the cells in that column to have multiple values, comma separated. Spotfire receives this data and tries to populate it into a data table, as a way to capture this data. An example cell value is "one, two, three".

The following article covers this topic, although does not clarify specifically the scenario, that a single cell has multiple comma-separated values: Accessing Data from Microsoft SharePoint Online (tibco.com)

Solution:

Spotfire is designed to allow importing of this type of data from Sharepoint Online. Available solution options are:

1. Modify the Sharepoint Online data and disable this feature in configuration, such that each cell has only a single value
2. Configure your Spotfire analysis behavior to work with multiple data tables.