Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 DeNormalizing data
#1
Hi all,

I am trying to build a logic for de-normalizing the source based on number of max groups. Can anyone please guide me how to achieve this.

sample input:
Name,College
Mo Williams,Alabama
Rondae Hollis-Jefferson,Arizona
Channing Frye,Arizona
Richard Jefferson,Arizona
Stanley Johnson,Arizona
Andre Iguodala,Arizona
James Harden,Arizona State
Bobby Portis,Arkansas
Patrick Beverley,Arkansas
Jeremy Lamb,Connecticut
Kemba Walker,Connecticut
Charlie Villanueva,Connecticut
Andre Drummond,Connecticut
Kyle Korver,Creighton
Doug McDermott,Creighton
Anthony Tolliver,Creighton

expected output:

College,col1,col2,col3,col4,col5
Alabama,Mo Williams,null,null,null,null
Arizona,Rondae Hollis-Jefferson,Channing Frye,Richard Jefferson,Stanley Johnson,Andre Iguodala
Arizona State,James Harden,null,null,null,null
Arkansas,Bobby Portis,Patrick Beverley,null,null,null
Connecticut,Jeremy Lamb,Kemba Walker,Charlie Villanueva,Andre Drummond,null
Creighton,Kyle Korver,Doug McDermott,Anthony Tolliver,null,null


Thanks
Ali
Quote
#2
What have you tried?

Also, why is this in "News and Discussions"?
Quote

Top Page

Forum Jump:


Users browsing this thread: 1 Guest(s)