Remove duplicate rows from table

Hi,

May I know how do i remove duplicated rows from table?
image
Thank you :slight_smile:

@esther there’s 2 ways to accomplish this:

  1. Add an aggregation to your table (i.e Record Count), and then hide that column by restricting the Max # Columns to 3

  1. Edit the expression on your first column (Country) and put a “distinct” in front of that column name, save it, and then refresh the visual.

The main issue here is that you’re not doing anything to restrict duplicate records from appearing in your select query. Either aggregating or adding a distinct statement to this query will help accomplish this.

1 Like

thank you, it’s working well.