Display only distinct rowsTag(s): Datawindow

First you need to Sort() the datawindow based on the columns that need to be distinct. After you apply a Filter(), to filter out the non-distinct rows.

For example, we have a datawindow with a column named prod_id and we want to display only one row for each prod_id.

First we turn off the datawindow redraw function to speed up the operation

Sort the rows based on the prod_id column Define the appropriate Filter Finally turn back on the datawindow redraw

---

---

---

---