topic Captilize in QlikView

Captilize

spikenaylor1 — Wed, 25 Nov 2020 16:16:04 GMT

I have the extract file then a transform file

I need to

in the transform file capitalize a field during load

The field already exists in the loaded extract file

I then need to

capitalize([Test Field]) as Test Field

I need the field name to stay the same

so basically I am updating the field during the transform

It wont let me use the same name

This is my transform script

MainData:

Load*

FROM

$(vPathQVDExtract)000_File_Extract.qvd

(QVD);

Calcs:

Load *,

MonthName([Date of Entry]) as Month,

YearName([Date of Entry]) as Year,

If([Target Completion date]='TBD' or [Target Completion date]='TBC' or IsNull([Target Completion date]),1,0) as TargetCompletionDate,

Capitalize([Action Status]) as [Action Status]

Resident MainData;

Re: Captilize

andrei_delta — Wed, 17 Oct 2018 09:16:29 GMT

hi,

Yes the error has it's right because you are loading the same field with the same name twice.

You can write it like this

Calcs:

Load *,

MonthName([Date of Entry]) as Month,

YearName([Date of Entry]) as Year,

If([Target Completion date]='TBD' or [Target Completion date]='TBC' or IsNull([Target Completion date]),1,0) as TargetCompletionDate,

Capitalize([Action Status]) as [Action Status2]

Resident MainData;

drop field [Action Status];

rename field [Action Status2] to [Action Status];

hope it helps,

Andrei

Re: Captilize

Anil_Babu_Samineni — Wed, 17 Oct 2018 10:44:36 GMT

You want from the field All Strings into UPPER? Then use UPPER() else If you want to get All first character from The Field value of different Words use CAPITALIZE()