Page 1 of 1

Value for a column in modify stage

Posted: Wed Dec 22, 2010 1:50 am
by austin_316
Hi,
Can anyone tell me if it is possible to assign a value from parameter set to the column created in using MODIFY stage.
i tried doing like this

Code: Select all

col1:String = #PARAMSET12.CRITICALITY1000#
CRITICALITY1000 in paramaterset has value HIGH
but i am gettng the warning
Modify_115: When checking operator: The modify operator has a binding for the non-existent output field "HIGH".
Copy_118: When checking operator: The modify operator keeps field "col1" which is not present in the output interface.
please help me on this.

thanks,
ravi.

Posted: Wed Dec 22, 2010 2:26 am
by ray.wurlod
Assignment of value is not possible in a Modify stage. You can do it in a Column Generator stage.

Posted: Wed Dec 22, 2010 2:32 am
by Abhi700
We Cannot Assign values in the Modify Stage.

Posted: Thu Dec 23, 2010 2:54 am
by Ravi.K
As suggested use Column generator and Assign your parameter to "Default" property at "EDIT Column Meta Data".

Refer the below thread.

viewtopic.php?t=137229&highlight=column+generator

Value for a column in modify stage

Posted: Thu Dec 23, 2010 11:03 pm
by austin_316
but is it possible to set value from Parameterse to this column? because my requirement is to set it from parameterset. please let me know if there are any stages other than transformer.

thanks,
ravi.

Posted: Fri Dec 24, 2010 3:56 pm
by ray.wurlod
Column Generator.
Build.

To name two.