topic OLEDB read failed SQL SELECT * FROM EMP in QlikView

OLEDB read failed SQL SELECT * FROM EMP

Fri, 02 Jan 2015 09:37:26 GMT

Hi All,

When I use the below code, getting the error:

EMP:

LOAD*,text(EMPNO) as EMP_NBR_Char,text(MGR) as MGR_NBR_Char,

SQL SELECT * FROM EMP;

OLEDB read failed

SQL SELECT * FROM EMP

But when I rename the ailas names, working fine.

EMP:

LOAD*,text(EMPNO) as EMP_NBR_Char1,text(MGR) as MGR_NBR_Char1,

SQL SELECT * FROM EMP;

Why?

Any idea? Thanks in advance.

arulsettu — Fri, 02 Jan 2015 10:16:52 GMT

try like this

EMP:

LOAD*,text(EMPNO) as EMP_NBR_Char1,text(MGR) as MGR_NBR_Char1;

SQL SELECT * FROM EMP;

SunilChauhan — Fri, 02 Jan 2015 10:25:08 GMT

indication of end of load should be ; inplace of '.

see below code

EMP:

LOAD*,text(EMPNO) as EMP_NBR_Char,text(MGR) as MGR_NBR_Char;

SQL SELECT * FROM EMP;

if you have same field name twice the this erro will occur and when you rename then it will execute.

so make sure EMP_NBR_Char and MGR_NBR_Char not exist in SQL SELECT * FROM EMP;

hope this helps

Fri, 02 Jan 2015 12:36:28 GMT

arulsettu,Actually I tried that method only.