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:
Regards,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)
;
Rajeev Prabhu