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

Clever_Anjos — Mon, 26 Sep 2016 12:02:17 GMT

SDUE:

LOAD *,

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

LOAD * FROM

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

LOAD

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

FROM

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

Anil_Babu_Samineni — Mon, 26 Sep 2016 12:03:27 GMT

What is the expected one from this

Right(Year,2) as AcademicYearShort

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

Anonymous — Mon, 26 Sep 2016 12:05:37 GMT

Hi Greg, try this:

SDUE:
LOAD *,

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

FROM

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

DROP FIELD AcademicYearShort; //IF IT EXISTS

RENAME FIELD AcademicYearShort_new TO AcademicYearShort;

Regards!!

puttemans — Mon, 26 Sep 2016 13:41:39 GMT

Hi Greg,

Can you tell how 'Year' looks like, and what you want as an end result?

If your 'Year' contains the actual year, then I would imagine your Academic year would look like Year-Year+1

In that case, you add

SDUE:
LOAD * ,

Year&'-'&(Year+1) as AcademicyearShort

FROM

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

If you need it like '15-'16 then it would become

'''&right(Year,2)&'-''&(right(Year,2)+1)

Regards,

Johan