Replicate the data set

Naga

Hi All,

Please help. I have a data set like below and I want that to convert to a data set like mentioned below.

 Input

Set 1	Price1	Price2
NA	10	11.5
NA	12	13.5
NA	15	16.5
NA	18	19.5
NA	18	19.5
NA	20	21.5

Output

Set 1	Price1	Price2
1	10	11.5
1	12	13.5
1	15	16.5
1	18	19.5
1	18	19.5
1	20	21.5
2	10	11.5
2	12	13.5
2	15	16.5
2	18	19.5
2	18	19.5
2	20	21.5

Venkatesh23

@Naga 

I have used the Text Input tool which is manually entered the values in the tool. You can use Instead of the Text input tool replace the required dataset for the input data tool. Connect (Input data tool) the S-> symbol of the Append tool and for the T-> symbol add the text input tool to duplicate the records how many times you want to repeat.

Regards,

Venkatesh