# How to get the Number of Distinct Values of a column?

**URL:** <https://community.automationedge.com/t/how-to-get-the-number-of-distinct-values-of-a-column/2338>\
**Category:** Get Help & Discuss\
**Tags:** rpa\
**Created:** [July 10, 2020, 7:42am UTC](https://community.automationedge.com/t/how-to-get-the-number-of-distinct-values-of-a-column/2338 "2020-07-10T07:42:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aswini.nayak](https://avatars.discourse-cdn.com/v4/letter/a/9fc348/32.png) [@aswini.nayak](https://community.automationedge.com/u/aswini.nayak)\
**Post date:** [July 10, 2020, 7:42am UTC](https://community.automationedge.com/t/how-to-get-the-number-of-distinct-values-of-a-column/2338/1 "2020-07-10T07:42:43Z")

</div>

How to get the Number of Distinct Values of a column?

---

<div class="post-metadata">

**Author:** ![madhavi.bade](https://avatars.discourse-cdn.com/v4/letter/m/50afbb/32.png) [@madhavi.bade](https://community.automationedge.com/u/madhavi.bade)\
**Post date:** [July 10, 2020, 8:14am UTC](https://community.automationedge.com/t/how-to-get-the-number-of-distinct-values-of-a-column/2338/2 "2020-07-10T08:14:41Z")

</div>

Hi,

```
 You can get Number of Distinct Values By using "Group By" step. Set Subject as Column name for which number has to be calculated and then select Type as "Number of Distinct Values (N)"
```