How to remove Duplicated rows from Chart Table

[Keitaru]

Found some duplicated data in my Flat Table Chart.

in my Backend data there is no duplicates however when adding the data to a flat table chart, the duplication occurs

As shown in the table image above.

[Mauritz_SA]

Hi Keitaru

Where are you getting the # field in the first column? The fact that there is a 7 & 8 for your one Incident ID makes it seem as if you do have duplicates.

Regards,

Mauritz

[Vegar]

From my experience, the duplicate rows are is most likely caused by a uncontrolled JOIN in the script. A join where you have more than one occurence of the join keys in one of the tables.

[Keitaru]

Measures: rowno(total) 

[Mauritz_SA]

Hi Keitaru

What @Vegar  said is probably what is happening then.

Regards,

Mauritz

[Vegar]

If you do have a row identifier, then you could check if you have duplicates in a chart/table using the row identifier as an dimension and count([row identifier])-1 as measure. The -1 will let most values become 0 except your duplicate rows.

[Keitaru]

Right now I've limit the number of keys to prevent any synthetic keys from occuring however my main data set is linked to various other table via a single primary key. I was thinking I'd this might be the cause of the issue.

Will try your method out see if it works.

[Keitaru]

Nope doesn't seem to work my duplicated row showed as 0 as well based on the unique identifier.