Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to generate ASCII values for an alphabetic sequence

Hi,
The sequence goes like A, B, C ...... Z, AA, AB, AC ..... AZ, BA, BB, BC.... BZ, CA, CB, CC....CZ, DA......ZA, ZB....ZZ, AAA, AAB, AAC....AAZ, ABA, ABB... AZZ, BAA, BAB....ZZZ
I want output as1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20........27,28,29,,,,,,,,,,,,,,,,,,,,,,,,,,,
using talend component .
Any suggestions thanks in Advance
Regards
VK

Labels (2)
3 Replies
Anonymous
Not applicable
Author

Hi
You can call the system function Numeric.sequence("s1",1,1) to generate a sequence number for each row. 

Best regards
Shong
Anonymous
Not applicable
Author

hi shong,
thanks for your reply
but if my input is A,B,C,D,AA,AB,AZ,BA,BF,BZ,ZZ,AAA,ZAB,ZZZ
THEN HOW COULD I USE  Numeric.sequence("s1",1,1)  


THANKS
VK
Anonymous
Not applicable
Author

Hi
Add one column in the output table of tMap, and set its expression as:
Numeric.sequence("s1",1,1) 

Best regards
Shong