Page 1 of 1
How to control the output of column in Column Generatorstage
Posted: Tue Mar 31, 2009 7:24 am
by 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
Re: How to control the output of column in Column Generators
Posted: Tue Mar 31, 2009 7:36 am
by tehavele
Absolutely.
Use 'Cycle' method.
Set Intial Value=1
Increament by = 0
Re: How to control the output of column in Column Generators
Posted: Tue Mar 31, 2009 7:39 am
by balu536
Will you please explain the same in detailed manner,I mean the "Cycle" funda(Where actually it needs to be set)
Regards,
Balakrishna
Re: How to control the output of column in Column Generators
Posted: Tue Mar 31, 2009 7:50 am
by 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.
Re: How to control the output of column in Column Generators
Posted: Tue Mar 31, 2009 7:52 am
by tehavele
Make sure that new column (ID) is an integer one.
Re: How to control the output of column in Column Generators
Posted: Tue Mar 31, 2009 7:59 am
by balu536
Thank you Teja.It's working
Posted: Tue Mar 31, 2009 4:04 pm
by ray.wurlod
Please mark this thread as Resolved using the green button at top.