Toad World® Forums

Non-Numeric Characters in Pivot

Greetings Toad Community.

I think I asked this question before, but is there any way I can add non-numeric characters in Pivot.

Results are something like this:

Col1

Col2

Col3

R1

C1

B

R1

C2

B

R2

C1

B

R3

C1

C

R3

C2

C

R4

C1

D

R4

C2

D

and the Pivot may be something like this:

C1

C2

R1

B

B

R2

C

R3

C

C

R4

D

D

This is very helpful with text analysis and aggregation.