topic Syntax error, missing/misplaced FROM in QlikView

Syntax error, missing/misplaced FROM

matfurrier — Wed, 07 Aug 2013 12:15:34 GMT

Friends, do not know what happens in this case. I tried several ways and always presents the same error. What can this be?

Syntax error, missing/misplaced FROM:
LIMITECLIENTE:
LOAD
ACCOUNTNUM AS[Código do Cliente],
CREDITMAX AS [Limite Total],
ATUAL AS [Limite Atual]
LIMITECLIENTE:
LOAD
ACCOUNTNUM AS[Código do Cliente],
CREDITMAX AS [Limite Total],
ATUAL AS [Limite Atual]

Below is the code that I created.

LIMITECLIENTE:
LOAD
ACCOUNTNUM AS[Código do Cliente],
CREDITMAX AS [Limite Total],
ATUAL AS [Limite Atual];
SELECT 
CUSTTABLE.ACCOUNTNUM, 
CUSTTABLE.CREDITMAX,
(CUSTTABLE.CREDITMAX - ISNULL((SELECT SUM (TMPCRE.VALOR) FROM AX501_SRL_PROD2.dbo.TMPCRE  WHERE TMPCRE.ACCOUNT = CUSTTABLE.ACCOUNTNUM AND TMPCRE.STATUS = 'ABERTO'),0))ATUAL
FROM AX501_SRL_PROD2.dbo.CUSTTABLE;
STORE LIMITECLIENTE INTO ;
DROP TABLE LIMITECLIENTE

Re: Syntax error, missing/misplaced FROM

Siva_Sankar — Wed, 07 Aug 2013 12:31:21 GMT

use sql before the select keyword. LIMITECLIENTE: LOAD ACCOUNTNUM AS[Código do Cliente], CREDITMAX AS [Limite Total], ATUAL AS [Limite Atual]; sql SELECT CUSTTABLE.ACCOUNTNUM, CUSTTABLE.CREDITMAX, (CUSTTABLE.CREDITMAX - ISNULL((SELECT SUM (TMPCRE.VALOR) FROM AX501_SRL_PROD2.dbo.TMPCRE WHERE TMPCRE.ACCOUNT = CUSTTABLE.ACCOUNTNUM AND TMPCRE.STATUS = 'ABERTO'),0))ATUAL FROM AX501_SRL_PROD2.dbo.CUSTTABLE; STORE LIMITECLIENTE INTO ; DROP TABLE LIMITECLIENTE regards. siva

Re: Syntax error, missing/misplaced FROM

hic — Wed, 07 Aug 2013 12:36:44 GMT

You need a space between AS and [Código do Cliente]

HIC

Re: Syntax error, missing/misplaced FROM

matfurrier — Wed, 07 Aug 2013 12:45:34 GMT

Friends, you are great!

Both answers helped me!

Thank you.

Hugs!