How to get distinct values from the data set in the data design?

RaviKumar_Rongali05
RaviKumar_Rongali05
edited February 11, 2022 in Analytics #1

Hi Experts,

In one of my business case, I need to create a data set with distinct values in the data design file. I know we can achieve this using cross tab but i have some limitation from the requirements point of view. so i need this to be implemented in the data set level. Can any one suggest me the solution ?

Thanks,

  • Ravi

Answers

  • jfranken
    jfranken E
    #2

    If the data set is populated by a query, simply do a SELECT DISTINCT query. If you aren't running a query, then you will need to use a Scripted data source and write code to eliminate duplicates.

    Warning No formatter is installed for the format ipb

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs