Skip to Main Content
Spotfire Ideas Portal

Casing clean-up recommendation

Add a recommendation to the data panel to clean up casing differences in a column similar to the existing spaces clean up recommendation.

Display the recommendation when a column contains values that differ only in casing. When selected, add a transformation that keeps the first encountered casing of a value (don't just lower or upper a column).

  1. Add new column: Rank(Lower([Data])) as [Data (casing rank)]

  2. Calculate and replace original column: First([Data]) OVER ([Data (casing rank)])

  3. Exclude added column [Data (casing rank)]

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Jun 8, 2021

      Thanks for an excellent idea. It's in our direction to add this capability (would probably be the first one) and other data cleansing insights to Spotfire.