How to filter rows based on unique values of a categorical column in TIBCO Data Science Team Studio

How to filter rows based on unique values of a categorical column in TIBCO Data Science Team Studio

book

Article ID: KB0070866

calendar_today

Updated On:

Products Versions
Spotfire Data Science Team Studio 6.3.2 and Higher

Description

How to filter rows based on unique values of a categorical column in TIBCO Data Science Team Studio?

Issue/Introduction

How to filter rows based on unique values of a categorical column in TIBCO Data Science Team Studio

Environment

Operating System: Linux

Resolution

To filter rows based on unique values of a categorical column in TIBCO Data Science Team Studio use Distinct operator.

1. Bring Data using a Database Operator and Preview the columns present in it.

User-added image

2. Use the 'Distinct' Operator to filter out the rows based on categorical values present in the Table.

User-added image

3. Once processed the Distinct values filtered from rows will be seen in the results tab.

User-added image


 

Additional Information

Refer to the official documentation for more information on Distinct operator