topic Re: Making changes in scipt editor to load field with changes to it in QlikView

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

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

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 — Mon, 26 Sep 2016 12:06:09 GMT

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 — Mon, 26 Sep 2016 12:06:32 GMT

May be like below:

SDUE:

Load *,

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

LOAD * FROM

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