I'm trying to add a calculated column to a data table with Information Designer

 Hi,

I created a calculated column in one of my datatables using Edit/Column properties/ insert calculated column. The column works, but now I'd like to move the calculation upstream into the Information Designer. I'm using Spotfire 7.0.

I tried to copy the column into the expression box and replaced the column name with the column alias %1. However, I get the following error when trying to add a datatable with this column.

What am I doing wrong here?

[[{"fid":"84001","view_mode":"default","attributes":{"height":"230","width":"1032","class":"media-element file-default"},"fields":{"format":"default","field_file_image_alt_text[und][0][value]":"","field_file_image_title_text[und][0][value]":""},"type":"media"}]]

Error message: Failed to execute data source query.

ImportException at Spotfire.Dxp.Data:
Failed to execute data source query. (HRESULT: 80131500)

Stack Trace:
at Spotfire.Dxp.Data.DataTable.<Refresh>b__15(Exception e)
at Spotfire.Dxp.Data.DataTable.BeginRefresh(Boolean showDataLoadReport, Boolean async, Action`1 continuation, DisposableCollection disposableCollection, Predicate`1 isLeafAffected)
at Spotfire.Dxp.Data.DataTable.Refresh(Boolean showDataLoadReport, Predicate`1 isLeafAffected)
at Spotfire.Dxp.Data.DataTableCollection.RefreshProducers(IEnumerable`1 tablesToRefresh, Boolean showDataLoadReport, Predicate`1 isLeafAffected)
at Spotfire.Dxp.Data.DataTableCollection.Refresh(IEnumerable`1 tablesToRefresh)
at Spotfire.Dxp.Forms.Data.DataFormsUserActions.<>c__DisplayClass8.<RefreshData>b__5()
at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

InformationModelException at Spotfire.Dxp.Data:
Failed to execute query: Remote org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "AS \"LABSRANGE\", [*]Real[*](right" at line 1, column 346.
Was expecting: "char" | "date" | "time" | "timestamp" | "cast" | "convert" | "any" | "array_agg" | "case" | "exists" ... (HRESULT: 80131500)

Stack Trace:
at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock()
at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at Spotfire.Dxp.Internal.Utilities.SeekableStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BinaryReader.FillBuffer(Int32 numBytes)
at System.IO.BinaryReader.ReadUInt16()
at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadMagicNumber(BinaryReader reader)
at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadSectionType(BinaryReader reader, SbdfSectionTypeId expectedType)
at Spotfire.Dxp.Data.Import.SbdfDataRowReader.DelayedInit()
at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.ExecuteQueryCore2()
at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()

InformationModelServiceException at Spotfire.Dxp.Services:
Failed to execute query: Remote org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "AS \"LABSRANGE\", [*]Real[*](right" at line 1, column 346.
Was expecting: "char" | "date" | "time" | "timestamp" | "cast" | "convert" | "any" | "array_agg" | "case" | "exists" ... (HRESULT: 80131509)

Stack Trace:
at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod)
at Spotfire.Dxp.Services.Data.InformationModel.QueryManagerService.GetDataBlock(String jobId, Int32 timeout)
at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock()

Thanks,

Kevin

(2) Answers

Login