Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

HI,

You can even try with

text(YourField) as CusID


Regards

ASHFAQ

View solution in original post

14 Replies
sushil353
Master II
Master II

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

Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

HI,

You can even try with

text(YourField) as CusID


Regards

ASHFAQ

sushil353
Master II
Master II

Hi SwathiRaj,

Have you tried

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

it is working fine.

HTH

sushil

Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

Hi, check if this helps

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

Regards

ASHFAQ

sushil353
Master II
Master II

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..

Not applicable
Author

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.

Not applicable
Author

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