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

];

[pooja_prabhu_n]

like below.

LOAD * INLINE [

    Name, Value

    BAR Chart, 1

    Bar Chart, 2

    BAR CHART, 1

    BB, 2

    PIE CHArt, 1

    Pie chart, 2

    Pivot Table, 3

    pivot TABLE, 1

];