Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Resident Script

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

Temp:

LOAD TA,

     [Month Name],

     TB,

     TC1,

     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;

4 Replies
Clever_Anjos
Employee
Employee

Which error is displayed?

sunny_talwar

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;

Anonymous
Not applicable
Author

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;

Clever_Anjos
Employee
Employee

I can see 2 possible issues

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

    TB,

    TC1,

    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;