cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate records due to different values

Former Member
0 Kudos

Hi Folks,

I have requirement of modifying an existing report which contains SKU,LableName,LableValue,RTSM. SKU and RTSM are unique across whole report. But they are repeating due to different values in LableName and LabelValue. For example,

SKU RTSM LableName LabelValue

10914010 5000-3013-7767-9931 HostName available

10914010 5000-3013-7767-9931 HostName trns00

The requirement is user wants unique records for each SKU,RTSM combination. I have thought of setting Master-detail. But any of you could please tell me any other alternative by which i can include lablename and labelvalue columns.

Thanks,

Manish

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

In Master Detail (Seciton) also you can add the lablename and labelvalue columns in the table. Just insert the balank column and use the coulmn lablename and labelvalue.

Also, try using apply brack on lablename and labelvalue columns. use brak Property for the required seeting you want to be display.

Former Member
0 Kudos

Is there any way to have unique records while still keeping lable name and label values?

Former Member
0 Kudos

I could see that there are 2 value trns00 & available in a column. So you are getting 2 rows respected to each value of "trns00 & available".

If you will remove this coulmn you will get distinct value.

You can user "Distinct" in the SQL query.

Also you have table propert "avoid duplicate row". But this will work only if you have duplicate rows. But here I can see there are 2 different value in a cloumn which is causing the display of the 2 rows.

Former Member
0 Kudos

Explain to the user the situation, ask how they want it presenting.

They cannot have both unique values of A and B as well as showing both versions of C and D! It's not physically possible.

You can present it whichever way they want once they know what they want. Welcome to the world of making the user decide what they actually want.

Former Member
0 Kudos

Hey guys,

Thank you very much for help and guide. I will ask the Analyst to explain the situation.