DSXchange

Thanks Ray. I will try it and update my post accordingly.

Hello,

We have a file with about 37 columns. We need to group the data based on 15 columns (let us say Column1 - Column 15) and then choose the first record based on Column 13. We are relatively new to DataStage and please let us know the best method of implementing the above logic.

Thanks.