topic Syntax error, missing/misplaced FROM: in QlikView

Syntax error, missing/misplaced FROM:

Anonymous — Thu, 22 Oct 2015 09:37:50 GMT

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 ?

Re: Syntax error, missing/misplaced FROM:

Thu, 22 Oct 2015 09:44:07 GMT

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.

Re: Syntax error, missing/misplaced FROM:

Gabriel — Thu, 22 Oct 2015 09:44:11 GMT

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;

Re: Syntax error, missing/misplaced FROM:

rubenmarin — Thu, 22 Oct 2015 09:44:20 GMT

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

Re: Syntax error, missing/misplaced FROM:

hic — Thu, 22 Oct 2015 09:45:17 GMT

You have two consecutive Load keywords:

LOAD Load * ,

HIC

Re: Syntax error, missing/misplaced FROM:

Peter_Cammaert — Thu, 22 Oct 2015 09:50:55 GMT

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...