Hello,
I have several lines which I would like to put on only one line.
I have
Key_1|Key_2
1 A
1 B
1 C
2 A
2 C
3 B
I want
1 A B C
2 A C
3 B
I do not know how much it can exist events.
How then to make?
Thanks
Muriel Auvray
several lines towards a line
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 43
- Joined: Wed Feb 19, 2003 7:17 am
- Location: France - Paris
- Contact:
Use stage variables (search the forum) to pivot your many rows into one. You'll have to add an extra row of data into your primary input stream to signal the end of the data to output the last row. Your data must be sorted and grouped.
Another method is to write to a hash file, referencing the row back and concatenating. This method works for unsorted data, but is slower than sorted data (which requires time for sorting anyway).
A third method is to use a custom script to manually roll up the data.
Another method is to write to a hash file, referencing the row back and concatenating. This method works for unsorted data, but is slower than sorted data (which requires time for sorting anyway).
A third method is to use a custom script to manually roll up the data.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle