How to get distinct value from a column

Mahulima
Mahulima Contributor
edited December 2023 in General

ex I have company value in a table with contact details one company has multiple contact and now I want to get the distinct value of the companies in the contact table

Best Answer

  • Sueann See
    Sueann See Experian Super Contributor
    Answer ✓

    @Mahulima i'm guessing you want to achieve this?

    image.png


    One way is to use the Group step, do a count on Company. The count tells you how many rows contain that Company value.

    image.png
    image.png


    image.png

    You can also refer to this article for other more flexible options.

Answers

  • Mahulima
    Mahulima Contributor

    @Sueann See Yes that is the way I did and achieve that but was looking for some function like distinct to get the result.

Categories