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: 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...
-
How to trigger a Python script at a given time interval using JavaScript/JQuery.
How to trigger a Python script at a given time interval using JavaScript/JQuery. The example in this article shows how a Script Button control can be triggered at a regular interval (1 second, in t...
-
Spotfire Client: Error: When trying to access Active Data Table or Marking using IronPython script you get 'System.MissingMemberException: NoneType object has no attribute ...'
When trying to access Active Data Table or Marking using IronPython script you get the folllowing error: Error: 'System.MissingMemberException: NoneType object has no attribute ...' If there is a r...
-
Spotfire Client: Error - "ImportException at Spotfire.Dxp.Data: Font 'Calibri' does not support style 'Regular'. (HRESULT: 80131500)" when opening any *.xlsx file in a Spotfire client.
When opening any *.xlsx file in a Spotfire client you get the following errorImportException at Spotfire.Dxp.Data: Font 'Calibri' does not support style 'Regular'. (HRESULT: 80131500)If you manuall...