topic Missing/Misplaced FROM error message in QlikView

Missing/Misplaced FROM error message

Mon, 04 Mar 2013 09:07:34 GMT

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];

Re: Missing/Misplaced FROM error message

Mon, 04 Mar 2013 09:13:33 GMT

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

FROM
[Durations.xls];

Re: Missing/Misplaced FROM error message

Mon, 04 Mar 2013 09:37:39 GMT

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!

Re: Missing/Misplaced FROM error message

perumal_41 — Mon, 04 Mar 2013 09:44:11 GMT

are u solved your porblem or not ?

Regards

Perumal A

Re: Missing/Misplaced FROM error message

Mon, 04 Mar 2013 09:51:17 GMT

Nope

Re: Missing/Misplaced FROM error message

perumal_41 — Mon, 04 Mar 2013 09:56:13 GMT

Hi,

Resident [StatusLog];

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

Resident [StatusLog];

Regards

Perumal A

Re: Missing/Misplaced FROM error message

Mon, 04 Mar 2013 10:03:29 GMT

Thanks!

I would never have found it myself!

Sometimes another pair of eyes is a must