Syntax error, missing/misplaced FROM:

[Anonymous]

When i execute the folloing error :

VenteFinal: 

LOAD Load * ,

IF(ISNULL(Comp) OR LEN(Comp) = 0 , 'O',Comp) as comparable

Resident TempVente;

drop table TempVente;

I got the following error

Syntax error, missing/misplaced FROM:

VenteFinal: 

LOAD Load * ,

IF(ISNULL(Comp) OR LEN(Comp) = 0 , 'O',Comp) as comparable

Resident TempVente

VenteFinal: 

LOAD Load * ,

IF(ISNULL(Comp) OR LEN(Comp) = 0 , 'O',Comp) as comparable

Resident TempVente

How to resolve it ?

[#2]

It appears that you are using Load two times instead of one:

VenteFinal:

LOAD Load * ,

IF(ISNULL(Comp) OR LEN(Comp) = 0 , 'O',Comp) as comparable

[...]

Remove one Load from the statement and it should be OK.

[Gabriel]

Hi,

The script is not straight forward but I think you're missing semicolon (;) at then end of

VenteFinal: 

LOAD Load * ,

IF(ISNULL(Comp) OR LEN(Comp) = 0 , 'O',Comp) as comparable

Resident TempVente;

[rubenmarin · Accepted solution]

Hi, you have two consecutive 'LOAD', remove one:

VenteFinal:

LOAD Load * ,

IF(ISNULL(Comp) OR LEN(Comp) = 0 , 'O',Comp) as comparable

Resident TempVente;

VenteFinal:

LOAD Load * ,

IF(ISNULL(Comp) OR LEN(Comp) = 0 , 'O',Comp) as comparable

Resident TempVente

[hic]

You have two consecutive Load keywords:

LOAD Load * ,

HIC

[Peter_Cammaert]

If Load is a field in your resident table, omit the asterisk and everything should be fine. With QlikView Script having no real keywords and all...