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

[#2]

any other valuable solutions please

[tresesco]

Try with Text(), like:

Load

          Text(ID) as ID

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

[sushil353]

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

[ashfaq_haseeb]

Try Like bleow

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

Regards

ASHFAQ

[MarcoWedel]

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