Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Which error is displayed?
Few things to note:
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;
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;
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;