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

[#1]

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

[sushil353]

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

[#3]

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

[ashfaq_haseeb · Accepted solution]

HI,

You can even try with

text(YourField) as CusID

Regards

ASHFAQ

[sushil353]

Hi SwathiRaj,

Have you tried

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

it is working fine.

HTH

sushil

[#6]

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

[ashfaq_haseeb]

Hi, check if this helps

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

Regards

ASHFAQ

[sushil353]

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

[#9]

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.

[#10]

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