Resident Script

[Anonymous]

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;

[Clever_Anjos]

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]

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]

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;