Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
Not applicable
Author

All you need to do is:

Load text(FIELD) as FIELD

SQL

select FIELD from table

View solution in original post

4 Replies
Not applicable
Author

All you need to do is:

Load text(FIELD) as FIELD

SQL

select FIELD from table

Not applicable
Author

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
Partner - Creator II
Partner - Creator II

Patrice,

Have you tried to_char(ITMREF_0) ?

Not applicable
Author

Yes I try but it's not possible

thanks