topic Capitalize column name in QlikView

Capitalize column name

sivarajs — Tue, 24 Feb 2015 08:04:14 GMT

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

Re: Capitalize column name

robert_mika — Tue, 24 Feb 2015 08:24:45 GMT

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

Re: Capitalize column name

awhitfield — Tue, 24 Feb 2015 09:51:08 GMT

As Robert say:

Load

TIME As Time,

DATE AS Date,

PLACE AS Place,

COUNTRY AS Country

from tmp;