topic import base oracle in qvd errors with fields '000001' and '000000001' just one in qvd in QlikView

import base oracle in qvd errors with fields '000001' and '000000001' just one in qvd

Mon, 26 Jan 2026 18:19:17 GMT

when i'm create a qvd in SQL SELECT i try to execute 'Text(field)' qliview send me an errors but it's neccesary to have the two lines in my qvd

'000001'

'000000001'

thanks for reply

best regards

Patrice

Fri, 15 Apr 2011 07:58:07 GMT

All you need to do is:

Load text(FIELD) as FIELD

SQL

select FIELD from table

Fri, 15 Apr 2011 08:18:18 GMT

yes i try this but for import direct to oracle base you not nead

load but

Itmmaster:

SQL SELECT

text(ITMREF_0)

as articl

FROM

PRODEF.ITMMASTER

store

Itmmaster into c:\QlikView\Data\Sap\itmmaster1.qvd;

and the system return an error:SQL Error:[Oracle][ODBC][Ora]ORA-00904: "TEXT": invalid identifier

SQL Scriptline:
SQL State:S0022
thanks

colinh — Fri, 15 Apr 2011 08:49:15 GMT

Patrice,

Have you tried to_char(ITMREF_0) ?

Fri, 15 Apr 2011 10:55:33 GMT

Yes I try but it's not possible

thanks