Ruchir

• Apr 7th, 2015

 

Use a vertical Pivot option available in Pivot Enterprise stage(Stage tab-->Properties-->Pivot Type=Vertical)

Again in stage-->Pivot properties tab-->group by on Name column and Pivot using City column.

Then select array size=3.

Nish

• May 25th, 2015

 

Pivot Enterprise stage is from 8.5 onwards. the generic solution would be to include a sort stage with key change column and then transformer stage with stage variables and field functions

praveen kumar

• Nov 19th, 2015

 

I have source like this
sno,marks
1,85
1,90
1,95

I want output like below
sno,maths,physics,chemistry
1,85,90,95

Without Using pivot Enterprise stage.

Abhinandan

• Nov 20th, 2015

 

Use 2 stage variable in transformer
Stagevar: if Stagevar1=sno then marks:",":Stagevar Else marks
Stagevar1: sno
map stageVar to marks

Sharali Sharna

• Nov 24th, 2015

 

You can use Pivot Enterprise stage to achive this.