Concatination

[srinu.dst]

Hi,
I have 3 records,
1 Srini
1 vasa
2 reddy

now i want o/p like this
1 Srinivasa
2 reddy

could u please help in this

Thanks in advance.

[chulett]

Stage variables to do group change detection and concatenate the 2nd column within a group. Then the Remove Duplicates stage set to retain the last 'duplicate' will give you what you want.

[nagarjuna]

Use sort stage with key column change option and use transformer to concatenate

[chulett]

... and then use the Remove Duplicates stage to retain the last record per group.

[ray.wurlod]

... making sure you use a key-based partitioning algorithm and sort on the key (in this case a stable sort is indicated).