15,996,848 members
See more:
Hi,i am reading data from excel sheet to sql table.i had a column name as 'traffic%'in sheet and values like 0.55%... when i load into the package it will give value as 0.0055.so i need to update it by multiplying by 100...how can i get the actual value from the package??????
Posted
Updated 31-Jan-17 1:43am
v2

Solution 1

In your workflow you will need to use the Derived Column object. In there you would select the excel column (the percentage one) and then "derive" a new column. This column can have an expression in it and you can do your multiplication there!

nagarjuna5388 8-Jun-12 7:32am
While i am trying to write the expression..it gives the o/p in table as -1.000000
in all the rows of '%column'
db7uk 8-Jun-12 8:08am
What is your expression and what is the datatype?
nagarjuna5388 8-Jun-12 8:41am
column name 'traffic%' datatype double-precision float....
i write expression in derived column as([traffic%]==[traffic%]*100)
my table column has datatype as 'numaric'
it gives all values as '-1.000000000'
db7uk 8-Jun-12 8:52am
I don't understand the [traffic%]==[traffic%]???? Should you not do [traffic%] * 100????

Solution 2

column name 'traffic%' datatype double-precision float....
i write expression in derived column as([traffic%]==[traffic%]*100)
my table column has datatype as 'numaric'
it gives all values as '-1.000000000'