Pivoting all rows into columns in target.

Hi @mahesh Ar,

Ataccama Desktop does not allow for a dynamic set of columns. Therefore, you need to decide beforehand what the maximum number of columns might be. If you are okay with this restriction, I suggest using the Group Aggregator step in conjunction with the maximumif function. The result could look like this:

In this example, I transpose up to 11 incoming rows, enumerated from 1 to 11.

In attachment a sample plan that uses Random Record Generator to generate 10 rows and the Group Aggregator step to transpose them up to 11 columns. 

Hi @mahesh Ar, to add to the suggestion from @AKislyakov - there's often more than one way to achieve a specific result in ONE Desktop. Another solution to your case could be to use the Representative Creator step, have a look at this example here: 

In your case you'd set the key to Group by as true:

And the acceptance conditions would be set according to your identifier values:

Hi @AKislyakov , The above example will return only 1 record as we are doing MAX, If the source has many rows each needs to be transposed. For eg) Total rows: 100 , Transpose them to 10 Columns with 10 rows Each. 

Basically the loop should continue for every 10th record, i dont think the above solution will work in that case