Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
1 Solution

Accepted Solutions

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

HI,

You can even try with

text(YourField) as CusID


Regards

ASHFAQ

14 Replies
sushil353
Honored Contributor II

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

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

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

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

HI,

You can even try with

text(YourField) as CusID


Regards

ASHFAQ

sushil353
Honored Contributor II

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

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

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

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

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

Hi, check if this helps

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

Regards

ASHFAQ

sushil353
Honored Contributor II

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

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

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

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

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

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

Community Browser