Skip to Main Content
Spotfire Ideas Portal

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
      Drop here to upload