Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Missing/Misplaced FROM error message

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

1 Solution

Accepted Solutions
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

Resident  [StatusLog];

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

Resident  [StatusLog];

Regards

Perumal A

View solution in original post

6 Replies
Not applicable
Author

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

FROM
[Durations.xls];

Not applicable
Author

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
Partner - Specialist II
Partner - Specialist II

Hi

are u solved your porblem or not ?

Regards

Perumal A

Not applicable
Author

Nope

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi,

Resident  [StatusLog];

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

Resident  [StatusLog];

Regards

Perumal A

Not applicable
Author

Thanks!

I would never have found it myself!

Sometimes another pair of eyes is a must