column to row

HemaV · Post by **HemaV** » Mon Mar 16, 2015 3:37 am

I/P:
ID,COLNAM,COLVAL
1,A,RAM
1,B,SHYAM
1,A,RAHIM
1,B,ROBERT
2,A,JOHN
2,B,JOHAN

O/P:
ID,A,B
1,RAM,SHYAM
1,RAHIM,ROBERT
2,JOHN,JOHAN

need help in designing this job.

chulett · Post by **chulett** » Mon Mar 16, 2015 7:57 am

What kind of help? What have you tried?

ps. This is a vertical pivot of rows to columns, not columns to rows.

HemaV · Post by **HemaV** » Mon Mar 16, 2015 8:18 am

Hi Chulett,

Sorry about saying column to row,I was confused.

I tried using vertical pivot using pivot enterprise stage,but I didn't get the desired output.

ex:
ID,A,B
1,RAM,ROBERT
1,RAHIM,SHYAM
2,JOHAN,JOHN

but my desired output is

O/P:
ID,A,B
1,RAM,SHYAM
1,RAHIM,ROBERT
2,JOHN,JOHAN

chulett · Post by **chulett** » Mon Mar 16, 2015 2:50 pm

Detail for us your entire job design / stages and then also the settings you used in the Pivot stage. I'd also be curious how may nodes you are running on and (if multiple) if it behaves differently if you drop it down from multiple nodes to a single node.