Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Nov 27, 2018

Add an Ignore Zeros option in an Unpivot transformation

I often have a table with a large number of zero values ( rather than null values) in soem columns that I then need to Unpivot. This results in a table with a large number of rows where the valu column is zero and this impacts overall performance.

There is already an option on the Unpivot Transformation to Ignore Null Values - it would be great if there could also be an Ignore Zeros option

  • Attach files