Added column in server table

[Cleto Nassabe]

Good day, i added a new column in a table stored in the server. Reloaded the data in Spotfire but it doesn't show the new column added.

How can Vizualize it in my dashboard?

[Fredrik Rosell]

Hello,

So either the new column is not getting imported, or it's imported but not displayed.

For the former, to start with, how are you importing the data - are you e.g. using an Information Link, a Connector, something else?

For the latter, how did you check for the new column - where did it not show up? Note that e.g. in a table plot, you may need to add the new column if the plot is not set to add new columns automatically, and in the Filters panel, you may need to add the filter if it's not set to create filters automatically. If you e.g. check in TIBCO Spotfire Analyst > Data menu > Column Properties > select the Data Table that should have the column, is the column listed there?

[Cleto Nassabe]

The column was added to SQL table

Although i reloaded the data (table) in Spotfire, it fail to show the new column added (SQL table) in the column list(column properties)

[Fredrik Rosell]

To show how the data is imported, please go to TIBCO Spotfire Analyst > Data menu > Data Table Properties > select the Data Table that your column should be in > select the Source Information tab, and copy that information and post it here (remove any sensitive data first).

Here's an example of what that may contain - in this example I imported data using an Information link.

1. Select Data > Add data...

  Type: Information Link

  Path: /Information Model/SQLServer2019_fro04/dbo/USERS

  Id: da342706-1b98-4b4d-a2ea-5fc2781ce390

  Data loaded at: 11/8/2022 2:36 PM

  Data was added as a new data table

[Cleto Nassabe]

1. Select Data > Add data...

  Type: Information Link

  Path: /Mozambique Subsurface/Gorongosa/$INFOLINKS/CORE_DATA

  Id: fd42d6a7-6d4c-41b3-8764-96cf0cb2761c

  Data loaded at: 11/8/2022 3:04 PM

  Data was added as a new data table

2. Data > Add hierarchy...

  Column name: Stratigraphy

  Hierarchy levels:

    [section]

    [Channel Belt]

    [Geobody I]

    [Geobody II]

3. Data > Add calculated column...

  Column name: Filtered Row

  Expression: BaseRowId()

4. Data > Add calculated column...

  Column name: Log10(K)

  Expression: Log10([Kair (md)])

5. Data > Add binned column...

  Column name: Binned Log10(K)

  Expression: BinByEvenIntervals([Log10(K)], 20)

6. Data > Data table properties > Relations

  Added relation: [Core Data].[Well] – [Wells].[Well]

[Fredrik Rosell]

Thank you! So, you are importing the data using an Information Link. To start with, please confirm that your information link has been updated to now also contain the new column that was added.

This is done using Information Designer, so (if you have access to that) go to TIBCO Spotfire Analyst > Data menu > Information designer, locate the Information Link (/Mozambique Subsurface/Gorongosa/$INFOLINKS/CORE_DATA), right-click on it and select "Edit" > Now confirm if your new column is included in the list of elements there. If not, it needs to be added (and if it hasn't been created already, you will need to create a column element for that new column first).