Issue with loading data into Flatfile

srini.dw · Post by **srini.dw** » Fri Jul 06, 2007 8:57 am

I am loading data from Dataset to Flatfile.
I need convert data Decimal(17,2) as Decimal(8,2) .

Sample Data 000000000002210.00
Result
002210.00

For getting above result i have to do....

If it's integer data i am doing like this

Str("0",6-Len(Trim(Move_EmplData.SAL))):Move_EmplData.SAL
Sample Integer Data 000000017000
Result
017000

Thanks
Srini

mandyli · Post by **mandyli** » Fri Jul 06, 2007 9:12 am

OK Srini,

You didn't mentioned your issue.

Thanks
Man

us1aslam1us · Post by **us1aslam1us** » Fri Jul 06, 2007 9:17 am

Use decimal_to_decimal function in the modify stage or try decimaltodecimal() in the transformer stage with proper floor value. These functions can be found in the manual.