topic Re: Upload Datatype conversion issues in QlikView

Upload Datatype conversion issues

snehamahaveer — Fri, 28 Aug 2015 11:11:55 GMT

Hi Everyone,

I am working on a dashboard which uses SQL upload for its data.

The problem I am facing is that when I use to_number() function to convert a Month from date and time field to number it gives a ORA 01481 error - invalid number format.

This is my SQL upload statement,

vat.EVTDATE AS EVENT,

to_char(vat.EVTDATE,'MON' ) as Month_Activity,

to_char(vat.EVTDATE,'(YYYY: DD,MON)' ) as MonthDay_Activity,

to_char(vat.EVTDATE,'MM') as Month_Activity_Num,

It works well with the to_char function and an error occurs only when I use to_number(). Where am I going wrong.?

to_number(vat.EVTDATE,'MM') as MM_Activity_Num,

Your help is much appreciated.

Re: Upload Datatype conversion issues

jonathandienst — Fri, 28 Aug 2015 11:17:53 GMT

This is more an Oracle question than a QV question. Perhaps you should post it in an Oracle forum.

Re: Upload Datatype conversion issues

PrashantSangle — Fri, 28 Aug 2015 11:30:58 GMT

Hi,

I agree with Jonathan, It is not QlikView issue.

Find below link might be helpful.

dba.stackexchange.com/questions/4941/oracle-format-specifiers-to-number-vs-to-char

Regards,

Re: Upload Datatype conversion issues

Ralf-Narfeldt — Fri, 28 Aug 2015 11:34:17 GMT

You could read the value raw from Oracle, and do the processing in QlikView instead, using QlikView functions in a preceding load.