joining rows

[kumar_s]

Try if this works for you:

Create a stage variable "Concatenated", initialize it as empty string (""), and it defined as:
If Concatenated = "" Then Input.ColumnD Else Concatenated : "/" : Input.ColumnD

Read through the sequential file and send the data to a hash table with 4 columns.
Column A, B, and C are the values from the source file. And use these three columns as the key of the hash;
Column = Concatenated

Did you mentioned about Hashed file
This is regarding PX.

[kumar_s]

Hi kumar

Its working fine now.But could you suggest me how to take the latest row from that rows.Coz when i am using the Rem Dup stage its giving me the first row not the last row as i need.

Thanks
sam

In both Sort as well as Rem Dup stage, the optiom to Retain First/Last are available in its properties.

[us1aslam1us]

HI all

Thanks Kumar,shepli and siva for your suggestions.

Sam