Spotfire Server: Error: "Invalid column name 'COLUMNNAME'" when opening information link using TIBCO Data Virtualization with Excel data source

You get "Invalid column name 'COLUMNNAME'" when trying to run information link created from a view published in Advanced Data Services Composite Studio through Excel data adapter (NON-ODBC) as data source 

The same view is working fine when running in Advanced Data Services Composite Studio. 

Running the view in Composite Studio (ADS) works fine but it throws an error when accessed by a Spotfire information link.
 

InformationModelException at Spotfire.Dxp.Data:
Failed to execute query: An exception occurred when executing the following query: "SELECT S1."Sample Date" AS "SAMPLEDATE", S1."Sputter Line" AS "SPUTTERLINE", S1."Product" AS "PRODUCT", S1."Sample Type" AS "SAMPLETYPE", S1."Remark" AS "REMARK", S1."CleanLine" AS "CLEANLINE", S1."TestCell" AS "TESTCELL", S1."Tester" AS "TESTER", S1."Lot_Id_code" AS "LOTIDCODE", S1."Lot_No" AS "LOTNO", S1."Slot_No" AS "SLOTNO", S1."Grade" AS "GRADE", S1."Glide_End_Time" AS "GLIDEENDTIME", S1."Small TA Top" AS "SMALLTATOP", S1."Small TA Bot" AS "SMALLTABOT", S1."Medium TA Top" AS "MEDIUMTATOP", S1."Medium TA Bot" AS "MEDIUMTABOT", S1."Large Void" AS "LARGEVOID", S1."Large TA Bot" AS "LARGETABOT", S1."Med+Large TA Top" AS "MEDLARGETATOP", S1."Med+Large TA Bot" AS "MEDLARGETABOT", S1."Total TA Top" AS "TOTALTATOP", S1."Total TA Bot" AS "TOTALTABOT" FROM "Sheet1" S1".  Cause: Invalid column name 'Grade'.  On line 1, column 332.  [parser-2900650]
com.compositesw.cdms.services.parser.ParserException: Invalid column name 'Grade'.  On line 1, column 332.  [parser-2900650]

This error is due to an extra space in the column name in Excel. 

To resolve, remove the extra space from the column name in the underlying Excel file(s) and save them