How to control the output of column in Column Generatorstage

[balu536]

Hi,
I'm using Column Generator stage and generating a column name DUMMY.Is there any possible way to control this column value i.e can i pass 1 as value under this column for all the incoming records,if so please explain me the procedure.



Regards,
Balakrishna

[tehavele]

Absolutely.
Use 'Cycle' method.
Set Intial Value=1
Increament by = 0

[balu536]

Will you please explain the same in detailed manner,I mean the "Cycle" funda(Where actually it needs to be set)


Regards,
Balakrishna

[tehavele]

Yes.Deifine the required field lets say as ID in the Column Generator Stage.In the OutPut page of this stage go to 'Edit Column Meta Data Box' by right clicking ID column and selecting 'Edit Row' option.Now in the 'Properties' option select 'Generator' box.Set 'Type=Cycle', Initial Value=1,Increament =0. This would ensure ID=1 in all the rows.

[tehavele]

Make sure that new column (ID) is an integer one.

[balu536]

Thank you Teja.It's working

[ray.wurlod]

Please mark this thread as Resolved using the green button at top.