Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

suman_dhar
Contributor

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;

Tags (1)
4 Replies
Employee
Employee

Re: Resident Script

Which error is displayed?

Re: Resident Script

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;

hrlinder
Honored Contributor

Re: Resident Script

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;

Employee
Employee

Re: Resident Script

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;

Community Browser