Spotfire dynamic column name. Aug 30, 2019 · As I trigger an action through a button, I managed to solve my problem by creating a new property containing the new column names and change this property by an IronPython script. For example, an IronPython script like this appends the value in "myCustomProperty" to the column name resulting in a column name like: "originalName (valueOfMyCustomProperty) ". e. In Spotfire, there are two ways to change column names. It does work on simple columns, but fails on column names with some special characters, like '[Name]', or 'Area [µm²] Aug 30, 2019 · However, I would like to change the column names dinamically when they contain a given string. Apr 18, 2019 · This is my first post on Medium, as I am trying to find new and better ways to reach Spotfire users and analytics practitioners. Nov 22, 2020 · Hi Gaia, I've attached a simplified dxp as an example. Edit the Text Area and add a List box (multiple select) control. Mar 7, 2024 · Paste-in the script below, edit it with relevant data, name it and click OK to close all settings. - Is there any chance to display coulumn only or rename the column name dynamically using scripts, if yes please 1 day ago · In a Combination Chart in TIBCO Spotfire, I am using Series based on a column that contains fixed values such as A, B, and C. Dec 11, 2025 · Learn how to work with the new column properties workflow in Spotfire 14. Apr 18, 2019 · In Spotfire, there are two ways to change column names. There are ramifications for which method you use, which I explained in this Data Shop Talk post. , change "Si 2" to "Si). I am also plotting Column1 and Column2, whose values change dynamically. . The display name can be something like 'Group 1' and the value, a comma separated list of columns i. I have tried the following, which however doesn't work as it returns the expression between [] Mar 26, 2020 · - when select the multiple value (more than one column) from property control, the column name displays with their aggregation (like Avg (Column Name), Sum(Column Name) in cross table. It takes a table and applies the column type change (the most simple and clear example shown below transforms numbers to strings). Ingredients: * Data Table Visualization * Text Area * Property Control Preparation: 1) Add a Data Table Visualization and a Text Area. You can now select a collection of columns to display using Property Control. As you can see, there are two line plots with normalisation and display elements chosen dynamicallywith document properties. Nov 5, 2019 · The “As” keyword allows us to rename columns of data on the axis of a visualization. 5 days ago · Hi, I have a problem with the IronPython script. I would like to remove the integer after the element name on the x-axes column labels (e. 'col2,col3,col4'. Aug 29, 2019 · This post has an example ironpython script that can be used to change column headers, using document properties. Feb 6, 2016 · The only option I can think of currently is to update the column name with the property value itself. g. Jun 14, 2021 · One way would be to create a drop-down property control of the values in your column, then use the name of that property control in the title, like: Scatter Plot of Connect: $ {Newchoice} Then it would change when you selected a different value in the property control. Note: The title automatically displays a dynamic name based on the columns selected on the X and Y axes. You can modify the column names in Column Properties, or you can change them with Transformations. 5+, including tips for editing, formatting, and managing columns efficiently. That property then can be read by visualizations (x-axis --> set as property for instance) or in other expressions. Jul 4, 2025 · In the attached dxp file, I added a script that reads the value of the calculated column into a document property. May 13, 2021 · So what do you do if you want to get rid of the aggregation and show only the column name? This post will show you how to connect a Spotfire display name to a property control without the aggregation for a clean and dynamic solution. Create a new property called 'groups' and add Fixed values for each item. When the user makes changes to the axis selector, the title updates itself accordingly. The script looks like this: It perhaps doesn't quite answer your question, but hopefully is useful. I am able to pivot the data to create summary values, however, I am unable to create a dynamic column name so that the "SCENARIO" name can change based on the project/user selection. If you modify the display name using the text box, under the covers, Spotfire writes an expression using the “As” keyword as shown below. Aug 4, 2025 · I have 4 cases that I need to rollup into 2 summary charts, Waterfall Chart, and Cumulative Chart. pbn kwj jmv wsd pcm mrn mlr ckv eks gvx ufr ufe ygb rzo tbc