How can I add a column that takes the number of the row for each key and column converted into rows
e.g.
from this:
key, c1, c2, c3
A, 10, 20, 30
to this:
key, count, value
A, 1, 10
A, 2, 20
A, 3, 30
Pivot Table - Row Counter
Moderators: chulett, rschirm, roy
Re: Pivot Table - Row Counter
Use Stage variables in Transformer.
A similar post was made on this site before. You can search for it.
viewtopic.php?t=86110&highlight=multiple
A similar post was made on this site before. You can search for it.
viewtopic.php?t=86110&highlight=multiple
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: