Capitalize all values of a column

[#1]

Hi all,

I have a requirement to load the data of particular column values in capital letters.Can you please help me on this.

I tried using capitalize function.but it doesn't work for my case.

Name
apple
orange
banana

Out Put :

Name
APPLE
ORANGE
BANANA

Thanks,

Chiru

[#2]

Below syntax has worked for me 🙂

LOAD upper(Name) as Fruitname from table.

Thanks,

Chiru

[jolivares]

Or simply at the moment of presentation put "Upper(Name)"

[#4]

Thanks, this help for me

[jolivares]

Mark as correct for others users...

[Colin-Albert]

There is a function Capitalize() in QlikView this just converts the first letter to Uppercase and all others are lowercase.

To change the whole text to capital letters use upper()

upper(Name)