Modify stage

[rajeev_prabhuat]

Hi,

I have a column that reads data with datatype as number and in PX this datatype is converted automatically to decimal (38,10) but my target is only Number(10,2). So i want to use to Modify stage to convert one format to another, can anyone let me know how we can achive this activity in Modify stage.

I tried POC work by defining the following in the modify stage in "Specification" part of Properties, A1:decimal(10,2)=decimal_to_decimal(A1) but i got the below error:

main_program: Error parsing modify adapter: Error in binding: Expected '=', got: "("
Expected destination field selector, got: ")"; input:
A1:decimal(10,2)=decimal_to_decimal(A1)
;

Regards,
Rajeev Prabhu

[Jay]

please do a search on Decimal Rounding....hopefully it will help you...

jay

[mandyli]

Hi

decimal (38,10) to Number(10,2) or integer default conversion not need for modify stage for conversion..