How do I suppress duplicates in a straight table?

[#1]

I can't use a pivot table for this, but I need to make sure that in the ITMSNumber column we are not showing any duplicates. PSA

[vinieme12]

Don't load the duplicates in your data, why do you have duplicate rows anyway?

[#3]

I'm asking the question so I don't have duplicate rows. I work in a large company so I don't know why there is duplicates. How would I go about writing an expression or a script to prevent loading duplicates?

[vinieme12]

Well the Question you asked was to hide the duplicate rows!

Anyways, firstly you need to identify what is creating those duplicates,

Are you doing a concatenation operation during data load, then add a flag to identify the source for your data for each record

[vinieme12]

if you don't want to do that exercise then just do

AGGR(concat(Distinct Fieldname),ITSMNumber) , in Calculated Dimension

[krishnacbe]

Hi,

Does the straight table has only two dimensions ITSM & Name?

If not then the other dimensions are causing the issue.  If Yes your expression should filter the duplicate rows.

[Clever_Anjos]

Please, try formatting ITMSNumber with more precision, maybe it has significant values after "."

[#8]

It has dimensions ITMSNumber, Name, AM Contact, Data Steward, Pr Yr, % Complete, Incomplete Fields, Data Ops Notes, IT Notes

[vinieme12]

this will work

AGGR(concat(Distinct Fieldname),ITSMNumber)

if your record has more distinguishing factors to identify a unique record then kep them adding to the AGRR()

else i would suggest using a key field that identifies unique rows Which i think should be ITSMNumber.

[krishnacbe]

Can you check only ITMS number & Name columns only have duplicate or entire row itself is duplicated.

I hope due to the Dimensions you have added it is showing distinct values. that is the representation of Straight table. If you don't want to view like duplicates then you need to convert the straight table to Pivot.