Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

eichinger
New Contributor

ORACLE: CONVERT NUMBER(17) TO STRING

Hello!

I have troubles to work with data stored as number(17) in oracle db. After loading data into app, i see a scientific representation of the number, which i can't handle.

Definition in oracle db:

1.png

View of data in oracle db with Oracle SQL Developer:

2.png

View of data in Qlik Sense data manager after load:

3.png

How can i convert this scientific number to normal number or string, as represented in Oracle SQL Developer?

Martin

1 Reply
eichinger
New Contributor

Re: ORACLE: CONVERT NUMBER(17) TO STRING

Hello!

SOLVED: it was only a problem representing the number. So it was not possible as expected to convert number2string implicit and get first 4 chars for year.

Now i cut milliseconds from timestamp first by dividing number / 1000 on load script.

LOAD VCE_NDATE_CREATED / 1000 as VCE_NDATE_CREATED, ...

Martin

Community Browser