DSXchange

Hi Everybody,
Wishing you all a very happy new year.

My datasource is a dataset (DS1) created by previous job.
I need to add another columns and pass on the new dataset (DS2)
(DS1 + new column)

This new column is numeric.
It is like appending another column with value 1 to DS1 to all the rows.

Could any one help me with that.

Thanks and regards,
Munish

Use Column generator stage to generate the new column.
In Columns tab Right Click --> Edit Row and give appropriate generator Properties to derive constant value of 1.

Yes, thats what I am using.
But my value is just one fixed number say 1 (numeric)
I am strugling to fill that column with that value (1).

Thanks

Munish,

You can do as per the Balaji's suggesstion. Where are you getting struggled? In the column properties you can mention as follows:

Hope this will help you to resolve your problem.

When you right click ---> Edit Row ,what is your generator type?

Set generator type = cycle. Set Initial value = 1 and Limit = 1.

Use a column generator to generate a column of type integer. In the column tab of the column generator stage, double click the name of the column(short-cut method). Add the type as cycle. Initial value as 1 and increament by 0(Initial value and Increament are tsub-property of type)

Munish wrote:Yes, thats what I am using.
But my value is just one fixed number say 1 (numeric)
I am strugling to fill that column with that value (1).

Thanks

Thats a confusing statement. Clarify please, else we will just be guessing.

Either of the two solutions will work for you. Initial value is 1. Either use 0 as the increment, in which case limit is irrelevant, or use limit 1, in which case increment can be any non-negative integer, but 0 or 1 is easiest.

Thanks Gentlemen,
It worked in the first instance itself,
Regards,
Munish