Missing/Misplaced FROM error message

[#1]

Hi,

I don't know where is the issue in the following script, which causes an error message, about a missing/misplaced FROM.

It relates to the part starting at [New Table].

The first load runs fine.

Thanks!

[StatusLog]:
LOAD [Case ID],
Events,
Started,
Finished,
Duration,
[Duration (milliseconds)]

FROM
[Durations.xls]


[New Table]:

LOAD
Year(Started) as YearStarted,
[Case ID] as CaseID

Resident[StatusLog];

[#2]

Put a ';' behind the FROM. Like this:

FROM
[Durations.xls];

[#3]

The original script has it. I just eliminted it by mistake from the original discussion text:

[StatusLog]:

LOAD [Case ID],

     Events,

     Started,

     Finished,

     Duration,

     [Duration (milliseconds)]

FROM

[..\Data\Sales Orders  - Durations.xls]

(biff, embedded labels, table is [Sales Orders  - Durat$]);

[New Table]:

LOAD

        Year(Started) as YearStarted,

        [Case ID] as CaseID

     Resident[StatusLog];

Thanks!

[perumal_41]

Hi

are u solved your porblem or not ?

Regards

Perumal A

[#5]

Nope

[perumal_41 · Accepted solution]

Hi,

Resident  [StatusLog];

you give  space between resident and table name .this is only problem.you  write  like

Resident  [StatusLog];

Regards

Perumal A

[#7]

Thanks!

I would never have found it myself!

Sometimes another pair of eyes is a must