• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Data result tree transform algorithm

 
Steve Jiang
Ranch Hand
Posts: 127
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The result set like below

L1 L2 L3
1 11 111
1 11 112
1 12 121
1 12 123
...
2 21 211
2 21 222
........

Need to output as tree,
output as tree,
L1 L2 L3

1 11 111,112
12 121,123
2 21 221, 222
..........


I can think the basic idea for that to convert it as tree, but a lot of checking and seems very complexity.

it seems a general operation after DB extraction and wonder if there is better or existing soluation?

Thanks!
[ July 18, 2005: Message edited by: Steve Jiang ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34229
341
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Steve,
Any available solutions probably depend on the output format. What are you trying to create? A web page? A Swing app? Plain text?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic