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
How to control the output of column in Column Generatorstage
Moderators: chulett, rschirm, roy
Re: How to control the output of column in Column Generators
Absolutely.
Use 'Cycle' method.
Set Intial Value=1
Increament by = 0
Use 'Cycle' method.
Set Intial Value=1
Increament by = 0
Tejas
Re: How to control the output of column in Column Generators
Will you please explain the same in detailed manner,I mean the "Cycle" funda(Where actually it needs to be set)
Regards,
Balakrishna
Regards,
Balakrishna
Re: How to control the output of column in Column Generators
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.
Tejas
Re: How to control the output of column in Column Generators
Make sure that new column (ID) is an integer one.
Tejas
Re: How to control the output of column in Column Generators
Thank you Teja.It's working
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: