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.
Go to Solution.
You can even try with
text(YourField) as CusID
Try using Num(CustomerId) while loading data.
or try below:
Num(Left(CustomerId, Index(CustomerId, 'E') -1) * Pow(10, TextBetween(CustomerId, 'E', '')))
Thanku yes tried with NUM but still same issue.let me check with above script
Have you tried
=Num(Left('3020E1', Index('3020E1', 'E') -1) * Pow(10, TextBetween('3020E1', 'E', '')))
it is working fine.
How it will work..can you pls explain little bit more
Hi, check if this helps
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.
Sure will mark it,but I want to clarify my question
SAP BO values
loading to QV ( it is automatically converting to number and I am getting duplicate names)
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.
I tried with num and text too but still same issue.