Page 1 of 1
column to row
Posted: Mon Mar 16, 2015 3:37 am
by HemaV
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.
Posted: Mon Mar 16, 2015 7:57 am
by chulett
What
kind of help? What have you
tried? 
ps. This is a
vertical pivot of
rows to columns, not columns to rows.
Posted: Mon Mar 16, 2015 8:18 am
by HemaV
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
Posted: Mon Mar 16, 2015 2:50 pm
by chulett
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.