How to remove duplicate values row in qlikview

[Anonymous]

Hi,Experts

My extracted data having duplicate values in a row.My data is below manner

Header 1	Header 2	Header 3	Header 4	Header 5
ID	NAME	MARKS	SCORE	PINCODE
1	RAM	34	2	3453
2	LRENU	44	7	909323
2	LRENU	44	8	909323
4	JOHN	54	6	3847
4	JOHN	54	4	3847
6	HUE	84	5	9303

Here I want to remove duplicate rows & getting  my output with based on max score.

The output is below manner

ID    NAME       MARKS     SCORE    PINCODE

1      RAM           34              2                 3453

2      LRENU        44              8                909323

4       JOHN          54               6               3847

6       HUE            84               5                9303

Thanks in Advance.

[Chanty4u]

try this

Data:

LOAD A,

    B,

C

FROM

tabl1;

Inner Join(Data)

LOAD

a,

max(Score) as NewScore

Resident Data

Group by Name;

[Anonymous]

At the time of  reload the edit script  show the output same as the excel sheet.But my output was above manner.

Thanks Chanty.

[yenumulagopi · Accepted solution]

Hi Suman,

Using Straight table we can do this.

Take the dimensions as ID, Name, Marks and PINCODE.

In the Expression : Sum(SCORE)

If you do this you will get the desire output

You can refer the attachment for better understanding.@

Thanks,

Gopi

[yenumulagopi]

Hi Suman,

use Max(SCORE).

Thanks

[Anonymous]

Hi Gopi krishna

Its good,the 2nd  row get the max score value(i,e.8).In my output the score value of 2nd row is 7.

Thanks.

[yenumulagopi]

Hi Suman,

You can check my 2nd post. It is matching with your correct output manner.

Thanks

[Anonymous]

You give me good suggestion.Its working.

Thanks Gopi krishna.

[yenumulagopi]

You Welcome.

Don't forgot to make it as correct answer.

Thanks