topic Re: Resident Script in QlikView

Resident Script

Anonymous — Mon, 09 Nov 2015 16:04:13 GMT

Please let me know why i am getting error in the resident clause-

Temp:

LOAD TA,

[Month Name],

TB,

TC1,

FROM

[\\TEST.xlsx]

(ooxml, embedded labels, table is Training);

INPUT_TRAINING:

LOAD TA,

[Month Name],

TB,

1 as Attr,

TC as PrD1,

TC1 as Val

Resident Temp;

Re: Resident Script

Clever_Anjos — Mon, 09 Nov 2015 16:06:12 GMT

Which error is displayed?

Re: Resident Script

sunny_talwar — Mon, 09 Nov 2015 16:06:29 GMT

Few things to note:

TC1 is repeating couple of times in your first load statement
Additional Comma after the second TC1

Try this may be;

Temp:

LOAD TA,

[Month Name],

TB,

TC,

TC1

FROM

[\\TEST.xlsx]

(ooxml, embedded labels, table is Training);

INPUT_TRAINING:

LOAD TA,

[Month Name],

TB,

1 as Attr,

TC as PrD1,

TC1 as Val

Resident Temp;

Re: Resident Script

Anonymous — Mon, 09 Nov 2015 16:06:53 GMT

there is no field TC in Temp, dou you mean TC1?

LOAD TA,

[Month Name],

TB,

1 as Attr,

TC as PrD1,

TC1 as Val

Resident Temp;

Re: Resident Script

Clever_Anjos — Mon, 09 Nov 2015 16:07:48 GMT

I can see 2 possible issues

1) You can´t have two fields in same load

TB,

TC1,

2) You don´t have the field TC into your Temp table

INPUT_TRAINING:

LOAD TA,

[Month Name],

TB,

1 as Attr,

TC as PrD1,

TC1 as Val

Resident Temp;