How to retain the first row obtained where we get duplicate values for a column?

[#1]

Hi all,

I have a scenario like

ID Supervisor

1   Krishna

1   Vamsee

2   -

2   Priya

Now I want the data to be displayed as

ID  Supervisor

1    Krishna

2    -

how can we achieve this?

[jonathandienst]

Hi

You have not indicated how the data should be sorted to use the first row or each value. If you are planning to use the supervisor name, then you should be aware that the null will always sort after the non-null values.

Do you want to do this in the load script or in a chart/table object?

For a chart, create one with dimension ID, and expression If(Rank(Supervisor) = 1, Supervisor))

Depending on what you want to do, look at Firstsortedvalue and rank functions to select the first row.

Regards

Jonathan

[#3]

Hello Jonathan,

I want to use it in a straight table,The sort order is the load order

I have tried using ID as dimension and rank() function as you mentioned in expression

The output straight table looks like

ID Expression

1   -

2   -

What is the meaning of this?

Thanks

Priya

[its_anandrjs]

Hi,

You have to use FirstValue( ) function in your load script.

Rgds

Anand

[its_anandrjs · Accepted solution]

Hi,

See the attached sample file it is your solution that you want You need to load data by FirstValue( ) function and use the fields in straight table or simple table box.

Let me know about this

HTH

Rgds

Anand