Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Aug 2, 2018

RELATED IDEAS

Ability to replace empty cells by a value in PIVOT transformation

When pivoting tall tables to make them wide, we end up with lots of empty cells that correspond to combinations that do not exist in the original tall data set. It is now very difficult to replace these empty values by a valid value (like 0) ... specially that PIVOT transformation ma create extremely wide tables.

The only alternative today is to use calculate & replace transformation for each column to replace Empty with 0 (for example).

We need an option in PIVOT transformation that allows this replacement ...  

  • Attach files
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