Develop a sequence for 3 digits alphanumeric like A01,A02,...A99.B01,B02,...C01,...Z99,AA1,AA2,...

[Anonymous]

I wanted to use a 3 digit alphanumeric sequence like :

A01,A02,..A99,B01,B02,....,Z99,AA1,AA2,...AB1,AB2,...ZZ9.

How to achieve this is talend?

[fdenis]

it's not just a sequence like hexa because you have your own logical.
can you have 001 or 000
can you have ZZZ
can you have A1A after A19

so you have to write your logical first then convert to an algorithme then to code it.
in talend you have to code in java.
If you want to retrieve it from a db you have to code it into db language.
the last solution is to fill a file with all possibilities (it's sometime quickest).