Duplicated data in table visual

Q&A
,
1

Hi,

image
image393×478 22.7 KB

I’m working with a dataset that contains duplicate records. While I can use ‘distinct’ counts in most visuals or via Quick Sight functions, I can’t seem to de-duplicate rows within a Table visual. Is it actually impossible to show only distinct rows in a table?

Thanks.

2

Hi @shay.davidovitch

The visual will display all the data from your dataset.

To remove duplicates, you may have to create calculated fields using window functions like rank and use it in filter to show only 1st row.

Thanks,

Kripa

3

Is it possible to use window function in QS?

4

Yes we have

Table calculation functions - Amazon Quick

5

Oh, that’s works as functions in the UI.
That means I should do it per column in the table uisual.

6

Hi @shay.davidovitch

Yes ,Are you able to fix it?

7

No, I didn’t try as i have around ten columns, so i used a distinctive table from the db.
It is not comfortable to create a distinct column per visual table column.

8

That’s a good workaround