Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have extracted data from data source using SAP extractor connector. But then I find that the data is in text form although it is a number. Is there any way I can convert data type of these texts into numbers?
Use the Num() function in your load
If it didn't convert automatically, use Num#() function at load, it interprets text as numbers in a specified format.
If for whatever reason you can't do it at load, you can even use Num#() in the chart expression (but that's likely to be very slow if you are going to need to agregate the result in any way).
Don't use Num(), that one is formatting something that is already a number.
Hi Prasad,
if the value is a string you will need to use Num#() and not Num() in your load.
Have a look at the below for a few examples of the different use cases
http://community.qlik.com/message/156115#156115
http://community.qlik.com/message/538561#538561
hope that helps
Joe
Hi Joe,
thanks for the information.
But I need to extract data from SAP infocubes so every time we need to do this or there is some setting can be done at the extraction level.
You would need to use the num#() function in your extract script yes, to adjust the field during the load