DSXchange

Here is my data
key seq field
1 1 f1
1 2 f2
1 3 f3
2 1 ff1
2 2 ff2

I want to get the following output

key field
1 f1,f2,f3
2 ff1,ff2

Looking for some assistance as to how to perform this in DataStage 11.5

I for one would be curious what you've tried so far. Did any of the things you've tried involve concatenating into a stage variable and a Remove Duplicates stage, perhaps? Or sorting and a KeyChange column?

Or... something else entirely?

I have tried using a sort/transformer but then realized that this will only create a single record.....I am interested in multiple records.....[also, I did not get the results I wanted but this is my error]

This can be easily solved using Transformer stage looping, using EndOfGroup() processing to detect the end of each key value (make sure you also partition by the key value).

Build the comma-delimited string using loop variables, and transfer to output only when the end of each group is reached.

There is an almost identical example in the IBM documentation, and in the IBM training materials.

I have solved the issue:

Using a Transformer Stage,

I created a Stage Variable to concatenate the columns I want together. This is based on the ClusterChangeKey set up by a sort stage just previous.

The other key point was to use a LastRowInGroup() as a constraint on the output so that I only get 1 record output when all of the rows that belong together are combined.

Thanx for the responses.

As with most things DataStage, there are multiple ways to solve this.