I want to generate alphanumeric series like below using Informatica PowerCenter and I am stuck coming up with business logic for the same.

A1,A2,A3….B1,B2,B3,….,C1,C2,C3,…C9..

I have used 2 sequence generator and 1 expression transformation.

1 sequence gen for series of numbers starting from 1 like 1,2,3,4,5…

1 sequence gen for series of numbers that cycles through number 1-9 like 1,2,3,…9,1,2,3..9,1,2,3..

1 expression transformation. Have attached image of ports that I’ve used.

The workflow completes fine but i am not getting desired output. Have attached the output that I’m getting as well.

outlook of my mapping – (https://i.stack.imgur.com/fdliL.png)

ports used in expression transformation – (https://i.stack.imgur.com/qAAPT.png)

output that I am receiving – (https://i.stack.imgur.com/mTxYm.png)