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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
psujini
Contributor
Contributor

sequence generate

Hi ,

 

Can any one tell how to generate the String sequence like

A001

A002

A003

'

'

'

 

 

Any Sugesstions!

Labels (1)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@psujini,please find the below screenshoot.

0683p000009LtJw.png0683p000009LtK6.png

 

Expression in tMap:-

'A'+String.format("%3s", String.valueOf(Var.var1)).replaceAll(" ", "0") 

View solution in original post

3 Replies
manodwhb
Champion II
Champion II

@psujini,please find the below screenshoot.

0683p000009LtJw.png0683p000009LtK6.png

 

Expression in tMap:-

'A'+String.format("%3s", String.valueOf(Var.var1)).replaceAll(" ", "0") 

manodwhb
Champion II
Champion II

still do you have a issue?

psujini
Contributor
Contributor
Author

Thank you!

its resolved