Capitalize column name

[sivarajs]

Hi,

Capitalize will change first letter in Cap followed by lower case if you apply to column. Is there a way we can change column name in same way at single point.

ex:

Load TIME,DATE,PLACE,COUNTRY from tmp;

Result column name should be Time,Date,Country,Place.How to achieve this?

Regards,

Sivaraj

[robert_mika]

I do not think you can change that at this stage

but you can try RENAME function(look into QLikview Help) or see this website

How to rename a field in qlikview

Rename fields in script

[awhitfield]

As Robert say:

Load

TIME As Time,

DATE AS Date,

PLACE AS Place,

COUNTRY AS Country

from tmp;