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
-
cgarciadesc
- Premium Member
- Posts: 2
- Joined: Tue Feb 24, 2004 11:50 am
Pivot Table - Row Counter
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
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
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
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: