Making changes in scipt editor to load field with changes to it

[Anonymous]

I am currently loading one of my data tables into Qlikview using the following script -

SDUE:
LOAD * FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

I would like make a change to one of the fields as it is loaded in -

   Year,'20'&right(Year,2) as AcademicYearShort,

How do I incorporate this in the LOAD script?

Thanks

Greg

[stabben23 · Accepted solution]

Not very Clear, but I'll try. Just do as below

LOAD *,  '20'&right(Year,2) as AcademicYearShort FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[trdandamudi]

May be like below:

SDUE:

Load *,

'20'&right(Year,2) as AcademicYearShort;

LOAD * FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);