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

Product:TIBCO Data Science Team Studio
Versions:6.3.2 and Higher

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

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

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.



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



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