
Anonymous
Not applicable
2018-01-11
11:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
View of data in oracle db with Oracle SQL Developer:
View of data in Qlik Sense data manager after load:
How can i convert this scientific number to normal number or string, as represented in Oracle SQL Developer?
Martin
- Tags:
- qlikview_scripting
1,330 Views
1 Reply

Anonymous
Not applicable
2018-01-15
05:41 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1,132 Views
