Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
matfurrier
New Contributor II

odbc read failed

My friends,

when creating the script below, an error is displayed on the screen, accusing odbc error in reading.

Can anyone help me?

Hugs.

HOMOLOGREPORT:

LOAD

DATA AS [Data],

CONSULTOR AS [Consultor],

CLIENTE AS [Código do Cliente],

NOME_CLI AS [Nome do Cliente],

PROD_HOM AS [Produto Homologado],

PROD_ESTR1 AS [Produto Estratégico],

PROD_ESTR2 AS [Produto Estratégico],

PROD_ESTR3 AS [Produto Estratégico],

PROXIMO_PASSO AS [Próximo Passo],

STATUS_VISITA AS [Status da Visita],

RESPONSAVEL AS [Responsável],

DESCRICAO AS [Descrição];

SELECT

DATA,

CONSULTOR,

CLIENTE,

NOME_CLI,

PROD_HOM,

PROD_ESTR1,

PROD_ESTR2,

PROD_ESTR3,

PROXIMO_PASSO,

STATUS_VISITA,

RESPONSAVEL,

DESCRICAO

FROM HOMOLOGREPORT;

STORE HOMOLOGREPORT INTO ;

DROP TABLE HOMOLOGREPORT;

Tags (1)
1 Solution

Accepted Solutions

Re: odbc read failed

The problem is that you cannot have 3 fields with the same name in the same table

  1. PROD_ESTR1 AS [Produto Estratégico], 
  2. PROD_ESTR2 AS [Produto Estratégico], 
  3. PROD_ESTR3 AS [Produto Estratégico], 
2 Replies

Re: odbc read failed

The problem is that you cannot have 3 fields with the same name in the same table

  1. PROD_ESTR1 AS [Produto Estratégico], 
  2. PROD_ESTR2 AS [Produto Estratégico], 
  3. PROD_ESTR3 AS [Produto Estratégico], 
matfurrier
New Contributor II

Re: odbc read failed

Perfect !

Hugs.

Community Browser