DSXchange

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

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

The Pivot stage does not do any transformations.
It's easiest to follow the Pivot stage with a Transformer stage. That's where you'd use the stage variable.