Jump to content

I have added a new column to a database table which is already used as a data source in spotfire .

Harry Harry

Recommended Posts

Thanks Addy . Actually i did that but still it was not showing up and I am also aware of the process to add that in IL . Even I was expecting it to be showing when I do the refresh .

But when I once again made the connection to the database for that data source ( i just gave the password and saved it again as-is) the new column was showing ..

Link to comment
Share on other sites

  • 1 month later...

If you need to show the new columns in an existing report as well, you need to use "File -> Repalce Data" with your newly edited Information Link.

If the new columns are not showing up in the data source after refreshing, in Information Designer, it might be the cache that is the culprit. Try changing the min or max number of connections, then change it back to what it was, this should have enabled the "Save" button that will release the cache and read everything a new.

Link to comment
Share on other sites

To expand on Addy's comment once the columns show in the data source you will need to add them as new column elements where your other column elements are, then you can add those to the infolink.

Once added to the infolink try and reload the table and see if the columns are added. Generally they will be added with out any fuss. No need to replace data table.

Link to comment
Share on other sites

  • 1 year later...
  • 2 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...