Spotfire: Error while executing Information Link with Distinct clause

Error while executing Information Link with Distinct clause

Details:

The following error is returned while executing the Information Link with distinct clause.
 

Unable to import data. 
at Spotfire Dxp Foms Data Import.TableContext DataFlowBuilderContext AddData Tables(DataManager dataManager, Fom baseFom, List'1& addedTables, String& errorMessage)
InfomationModelException at Spotfire.Dxp Data
An Intemal Error has occurred. com.spotfire.ws.dat.OperatorException: unexpected exception (HRESULT: 80131500)

This is caused as the SQL is modified manually and the number of columns returned should not be altered.

From the manual: 

Note: The modified SQL is not validated before execution. For this reason, you should not:

• alter the name of a column (the AS-part of SELECT xxx AS yyy)
• alter the number of columns returned
• alter the datatype of columns returned
• alter the order of columns returned
• remove <temporary_result_#> from the FROM-clause in information links that go against multiple data sources
• remove the trailing WHERE <conditions>, as it will be replaced by any conditions applied at runtime

Uncheck the Retrieve column for the columns that will not be returned from the Information Link editor. See the below screenshot: