Quick Distribution of Unique Records

Need to get a quick overview of unique records in your data? Count Unique shows you the distribution of records for a given column (i.e., data field). It is an excellent node for data clean-up as it gives you a snapshot of your before you begin to trim your data.


How Do I Add The Count Unique Node?

Add Count Unique to any node in your Dataflow. Select any node and use the Transform (+) button to open the list of options to select d Count Unique. You could work with the node in the Dataflow tab or use the Properties panel.


How Do I Use Count Unique?

Use the dropdown to select a column. Count Unique will return how many records exist for each unique value in the selected column.