Remove Duplicate Rows

✓ Compatible with desktop and web

 

Description

What do you do when you have duplicate rows? This template shows how to create calculated columns which make duplicate values NULL. This is useful for reading the table as well as necessary for some visualization and aggregation setups.

 

The Bar Chart demonstrates the effect. The chart shows how many hours each Bit has been running in total using the calculated column Hours_displayOneOnly. Not using our calculated column but usingSum(Hours) would double or even triple the numbers.

Features

  • Use Calculated Columns in Spotfire to only display one value among duplicate rows.
  • Creates a new column with a NULL value for duplicates, in effect removing it from future aggregations and visualizations.
Installation

A template is an analysis file created in TIBCO Spotfire. The intended use is to replace the data and utilize the configured visualizations and calculations.

  1. Download the template to your personal machine. Login into your own Spotfire server and open the downloaded file.
  2. Review the tables shown on the data load page. These are the tables you'll replace.
  3. Replace the data with another Excel sheet or connect the template directly to your database or platform.
  4. Customize with your own data. You are free to embed and incorporate your template into other projects.
  5. All done!

Spotfire Templates are provided as is and do not require licenses.

Leave a Reply

Your email address will not be published. Required fields are marked *

Download Details

Remove Duplicate Rows

62 sales

Cart

  • Your cart is empty.
Product Details
Release date: October 19, 2017
Last updated: October 19, 2017
Current version: 1.0
Software application type: Spotfire Template
File format: .dxp
File size: 1MB
Requirements: TIBCO Spotfire 7.9+
Posted In:  
Tags:

Copyright 2020

Petro.ai