Rounding Data in FDM from SQL Table

User607524-OC Mar 4, 2014 3:48 PM

I am trying to round data in FDM Action > Export script as the data is coming from SQL Table without rounding.

I have update the Export script with below but it does not make any changes to the Dat file.

Has anyone used this in the Adaptor Export script?

'Amount

strLine = strLine & Round(rsExport.Fields("Amount").Value)& strDelim

Thanks

1. Re: Rounding Data in FDM from SQL Table

Francisco Amores Mar 4, 2014 5:44 PM (in response to User607524-OC)

Hi
is not possible for you to round when importing into FDM instead of exporting to target?
i would recommend this rather than export action script.
Like Show 0 Likes(0)

Actions
2. Re: Rounding Data in FDM from SQL Table

Francisco Amores Mar 4, 2014 5:49 PM (in response to User607524-OC)

If you use export action script make sure you adjust the correct line as EXPORT action manages both single and multi period data exports.
also try casting to double as value exported is string.
1 person found this helpful
Like Show 0 Likes(0)

Actions
3. Re: Rounding Data in FDM from SQL Table

User607524-OC Mar 5, 2014 1:31 PM (in response to Francisco Amores)

Hi,
I found that the "Amount" should "Amt" not sure but it's been abbreviated. I also had to add to other instances to get the rounding to work.
Thanks
Like Show 0 Likes(0)

Actions
4. Re: Rounding Data in FDM from SQL Table

Francisco Amores Mar 5, 2014 1:43 PM (in response to User607524-OC)

Good.

Please mark the question as answered so others can see.

Thanks
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.