Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Jun 8, 2021

RELATED IDEAS

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
  • 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.

This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us