How to remove duplicate dimensionsin pivot table one in upper case one in lower case

[aditi_haldule]

Hi,

Vizlib Pivot Table is showing duplicate values. I have to list out regions so it is showing : EAST and east in the table and same for other type of regions. The data however only has EAST. Why are duplicate values visible and that too in the lower case?

How can I remove them? Please help

Thanks

[rubenmarin · Accepted solution]

Hi values are case sensitive so 'east'<>'EAST', you can use the upper() funcion in script to convert all values to uppercase: LOAD Upper(FieldName) as FieldName

[aditi_haldule]

Thank you! This worked