DSXchange

Posted: **Fri Feb 24, 2006 4:37 pm**

shepli wrote: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.

Posted: **Fri Feb 24, 2006 4:40 pm**

us1aslam1us wrote: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.

Posted: **Fri Feb 24, 2006 5:28 pm**

HI all

Thanks Kumar,shepli and siva for your suggestions.

Sam

DSXchange

joining rows