topic how to handle exponential value while loading from SAP BO to QV in QlikView

how to handle exponential value while loading from SAP BO to QV

Mon, 26 Jan 2026 21:26:37 GMT

Hi all,

I have strange issue,I loaded data from SAP BW to QV, While loading customer table from SAP BO to QV I am seeing two different customer IDs like 302000,3020E1

But in QV it is taking as single customer ID like 30200 for both,So I am facing duplicate issue in my data model.

How we can handle this types issues,please provide your valuable suggestions.

Thanks

Re: how to handle exponential value while loading from SAP BO to QV

sushil353 — Thu, 16 Oct 2014 07:31:59 GMT

Hi,

Try using Num(CustomerId) while loading data.

or try below:

Num(Left(CustomerId, Index(CustomerId, 'E') -1) * Pow(10, TextBetween(CustomerId, 'E', '')))

HTH

Sushil

Re: how to handle exponential value while loading from SAP BO to QV

Thu, 16 Oct 2014 07:36:23 GMT

Thanku yes tried with NUM but still same issue.let me check with above script

Re: how to handle exponential value while loading from SAP BO to QV

ashfaq_haseeb — Thu, 16 Oct 2014 07:37:11 GMT

HI,

You can even try with

text(YourField) as CusID

Regards

ASHFAQ

Re: how to handle exponential value while loading from SAP BO to QV

sushil353 — Thu, 16 Oct 2014 07:38:27 GMT

Hi SwathiRaj,

Have you tried

=Num(Left('3020E1', Index('3020E1', 'E') -1) * Pow(10, TextBetween('3020E1', 'E', '')))

it is working fine.

HTH

sushil

Re: how to handle exponential value while loading from SAP BO to QV

Thu, 16 Oct 2014 07:41:35 GMT

How it will work..can you pls explain little bit more

Re: how to handle exponential value while loading from SAP BO to QV

ashfaq_haseeb — Thu, 16 Oct 2014 07:43:04 GMT

Hi, check if this helps

http://community.qlik.com/thread/137959

Regards

ASHFAQ

Re: how to handle exponential value while loading from SAP BO to QV

sushil353 — Thu, 16 Oct 2014 07:46:54 GMT

It is simply multiplying the values from the left side of E in the string with the power of 10 to the right of E...

In the above case 3020 * (10*1) = 30200

Please mark this thread as answered if your issue is resolved for others to get benefited.

HTH

Sushil..

Re: how to handle exponential value while loading from SAP BO to QV

Thu, 16 Oct 2014 08:13:25 GMT

Sure will mark it,but I want to clarify my question

SAP BO values

-------------------

ID Name

3020E1 A

302000 B

loading to QV ( it is automatically converting to number and I am getting duplicate names)

---------------------

ID NAME

302000 A

302000 B

I don't want to convert exponential value to number when I load from Source DB,I need to load same as source value.

Hope you understand my issue.

Re: how to handle exponential value while loading from SAP BO to QV

Thu, 16 Oct 2014 08:21:28 GMT

I tried with num and text too but still same issue.

Re: how to handle exponential value while loading from SAP BO to QV

Thu, 16 Oct 2014 09:13:10 GMT

any other valuable solutions please

Re: how to handle exponential value while loading from SAP BO to QV

tresB — Thu, 16 Oct 2014 09:18:19 GMT

Try with Text(), like:

Load

Text(ID) as ID

Edit: Ohh, you tried that. Could you post the script line how exactly you tried ?

Re: how to handle exponential value while loading from SAP BO to QV

sushil353 — Thu, 16 Oct 2014 09:23:48 GMT

Hi,

To make a num to be treated as text..

you can simply use. .TEXT() function to convert it..

In your above example

ID NAME

302000 A

302000 B

since the name is different for same id.. so the entire row is treated as distinct row..

Re: how to handle exponential value while loading from SAP BO to QV

ashfaq_haseeb — Thu, 16 Oct 2014 09:28:42 GMT

Try Like bleow

num(Num,'######')

Regards

ASHFAQ

Re: Re: how to handle exponential value while loading from SAP BO to QV

MarcoWedel — Thu, 16 Oct 2014 10:02:23 GMT

Hi,

if you don't need exponential number notations throughout your whole application, the easiest way might be to define this variable before your load/select statement:

Set ExponentNumberNotation=0;

hope this helps

regards

Marco