Skip to Main Content
Spotfire Ideas Portal
119 VOTE
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on May 12, 2020

Spotfire Analyst - Add more information for transformations in the Data Canvas

When displaying the transformations under the Data Canvas, when many transformations are performed, it is tricky to just have the transformation sequence number, without the name of a column for example. This would lead to Edit several times in the Transform data window.

After clicking on a data table, displaying the transformations.

  1. Change column names

  2. Filter rows

  3. Caculate new column

  4. Caculate new column

  5. Caculate new column

  6. Caculate new column

  7. Caculate new column

  8. Caculate new column

  9. Caculate new column

  10. Caculate new column

  11. Caculate new column

  12. Caculate new column

  13. Caculate new column

  14. Caculate new column

When clicking on the 3 vertical dots to edit the transformations, a list appears in a new "format". Only the performed action is displayed. No sequence number.

Change column names

Filter rows

Calculate new column

Calculate new column

Calculate new column

Calculate new column

Calculate new column

Calculate new column

Calculate new column

Calculate new column

Calculate new column

Calculate new column

Calculate new column

Calculate new column

Calculate new column

Calculate new column

The Transform data windows is lacking transformation sequence number and column name / single value where applicable.

Example of enhanced view:

  1. Change column names

  2. Filter rows

  3. Caculate new column - External ID

  4. Caculate new column - Internal ID

  5. Caculate new column - Enchanved View

  6. Caculate new column - New Idea ID

  7. Caculate new column - City

  8. Caculate new column - Region

  9. Caculate new column - Country

  10. Caculate new column - World

  11. Caculate new column - Galaxy

  12. Caculate new column - ...........

  13. Caculate new column - ...........

  14. Caculate new column - ...........

...

Could TIBCO enhance these views?

Thank you for your consideration.

  • Attach files
  • Guest
    Reply
    |
    Jun 14, 2022

    I just add the possibility to name the transformation step.

    Just like in Power Automate :)

42 MERGED

Add Note/Description for Data Transformations

Merged
It would be very useful to be able to add a few words as a note/description for a data transformation, and have this note viewable in the list of transformations that have been applied to a data table. This would help to allow an analyst to quickl...
over 3 years ago in Spotfire / Data Management 0 Future Consideration
8 MERGED

Present in Canvas the name of calculation for transformation "Calculate new column"

Merged
We have a large number of calculated columns created with transformation. The names of the calculations are the same - "Calculate new column" In case we need to change the calculation - we need to check every transformation. Please add an option ...
about 5 years ago in Spotfire / Data Management 0 Future Consideration
8 MERGED

Calculate and Replace Column - Column Names

Merged
If more columns replaced using "Calculate and replace Column" transformation, need to open all transformations and difficult to identify the required column to make any changes. Provide the column name next to the performed transformation or provi...
over 3 years ago in Spotfire / Custom Expressions 0 Future Consideration
5 MERGED

Allow data transformations to be named in data canvas

Merged
It's hard to understand a data flow in the data canvas when data transformations do not have informative names. I might have a dozen or more, and they are all either "Added rows" or "Added columns". I need to be able to name them, and also add a d...
over 2 years ago in Spotfire / Data Management 0 Future Consideration