Hansen, Stefan
- Total activity 215
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 42
Articles
Recent activity by Hansen, Stefan-
Spotfire Client: How $csearch function works when you have spaces in column names
This article gives brief overview of how $csearch function works and how it is different from the wildcards used in SQL.Selects a number of columns from a data table using a limiting search express...
-
How to find the difference between two selected minimum and maximum values.
Below is an example of selecting a two date value and finding the difference between them.Create a text area to be able to select a minimum date and a maximum date, setting a document property. You...
-
How to find out who deleted a folder in Spotfire Library?
Here are the steps that you need if you want to find what user created or deleted a folder in the Spotfire LibraryIn the Spotfire Server <Spotfire Server installation dir>/tomcat/logs folder you wi...
-
Spotfire Client: The difference between Rank & DenseRank with an example
To illustrate how Rank and DenseRank functions are used, assume we want to assign a sequential order, or rank, to people within a department based on salary. We might create a new calculated column...
-
Spotfire Client: Connecting to MS Access database via ODBC may result in 'Too many fields defined' error
When using Spotfire to connect to an MS-Access Database via ODBC you can see the following error:OdbcException at ACEODBC.DLL: ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Too many field...
-
How to flag changes in column values if they have changed over a particular day.
How to flag changes in column values if they have changed over a particular day.Let's take an example of a daily stocks dataset with two columns "DATE" & "Stock".The stock price is prone to change ...
-
Spotfire Client: When geocoding is used for Canadian addresses, postal code matching fails.
When creating a map with Canadian addresses, the user is unable to use the postal code as a geocoding table match because our geocoding tables only include the first three characters and not the fu...
-
Spotfire Client: How to convert to "mm/dd/yyyy" format.
For this example, the Julian dates are in the column [StartDate] with one of the [StartDate] values being 202360. This article walks through how to convert this value to mm/dd/yyyy format using cal...
-
Spotfire Client: What character sets are used in the Japanese Language Pack?
The User Interface (UI) and Help files are displayed using a mixture of "kanji", "katakana" and "hiragana" characters. These three character sets can also be read into the program and displayed in ...
-
Spotfire Client: How to set the order in which markers are rendered in a Scatter Plot?
There are cases when the order in which markers (plotting symbols) are drawn can make a difference in how the visualization appears. If multiple data points are at the same location on the plot, yo...