Value for a column in modify stage

austin_316 · Post by **austin_316** » Wed Dec 22, 2010 1:50 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 22, 2010 2:26 am

Assignment of value is not possible in a Modify stage. You can do it in a Column Generator stage.

Abhi700 · Post by **Abhi700** » Wed Dec 22, 2010 2:32 am

We Cannot Assign values in the Modify Stage.

Ravi.K · Post by **Ravi.K** » Thu Dec 23, 2010 2:54 am

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

austin_316 · Post by **austin_316** » Thu Dec 23, 2010 11:03 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 24, 2010 3:56 pm

Column Generator.
Build.

To name two.