Display first row when duplicate records exists in straight table.

[pooja_prabhu_n]

Hello everyone,

I have a table where records are stored in both upper case and lower case like below.I want to display only one row(firstsortedvalue) for Name="Bar chart" instead of 3 lines without converting it to any other format like upper,lower, capitalize.I am using the Name column in dimension.

LOAD * INLINE [

    Name, Value

    BAR Chart, 1

    Bar Chart, 2

    BAR CHART, 1

    BB, 2

];

[MK_QSL]

Use

UPPER(Name) as Dimension

and

SUM(Value) as an expression

[pooja_prabhu_n]

Thanks for the quick response. But i don't want to convert it to any other format like Upper, lower, capitalize. I just want to display the first value as it is.

[Anonymous]

Is there any specific reason that you do not want to use upper/lower etc.? What you want to accomplish can easily be done using Manish's reply above.

[MK_QSL]

How you decide which one is your first value?

[HarishG]

you can use as Manish Kachhia suggested....or you can try this as well..

=if(WildMatch(Name,'*Bar*'),'BAR Chart',Name)

[pooja_prabhu_n]

I am just sorting it according to first loaded value.

[pooja_prabhu_n]

My requirement is to display only one value without changing it to upper or lower. In actual data user don't want to change it's format.

[pooja_prabhu_n]

This solution would be helpful when we have less number of records. But , i have multiple number of records in my actual table.

[HarishG]

Multiple number of records as in? can you show or send us the formats or records?