Num#() in Oracle

[priyarane]

Hi Community,

Due to some reason I can't use Num#() in load script but need to implement same in Select statement (oracle DB) in Load script of QVW. But didn't find exact match of Num#() in oracle, so can someone pls suggest.

_Priya

[sergio0592]

Hi,

Try with to_number  Oracle function.

[priyarane]

it didn't work,

I have values like 

Dim1

0

0.2

0.199992

12.5

2.93847

So I want to get all values after decimal.

[Vegar]

Try

Sql select

TO_NUMBER(Dim1, '99.9999999')

From db

[Brett_Bleess]

Priya, did Vegar's post get things working for you?  If so, please be sure to use the Accept as Solution button to mark his post as correct and give him credit.  If you are still having issues, leave an update on where things stand.  The only other thing I could recommend would be checking the Oracle Community, as they would be the experts on this one as well...

Regarding the Load statement side of things, sometimes you have to use a combination of the formatting functions to get what you really want, just FYI, and in this case, what would have probably helped is if you could have attached a sample QVW with the issue and maybe a QVD with some of the source data, so we could have tried to figure out why things were not working for you in the Load statement.  

The following Design Blog post may be of some further help possibly:

https://community.qlik.com/t5/Qlik-Design-Blog/Automatic-Number-Interpretation/ba-p/1475352

Regards,
Brett

[priyarane · Accepted solution]

Working with below statement

rtrim(to_char(x, 'FM999999999999990.99'), '.')