Skip to main content
Unlock a world of possibilities!
Login
now and discover the exclusive benefits awaiting you.
Expand
Qlik.com
|
Qlik Help
|
Resources
Ask a Question
All community
This category
This board
Knowledge base
Users
Products
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Sign In / Register
All community
This category
This board
Knowledge base
Users
Products
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Forums
Support
Discover
Greenway
Opens new window
Qlik.com
Qlik Help
Resources
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration!
REGISTER TODAY
and save!
Qlik Community
:
Forums
:
Data Integration
:
Talend
:
Design and Development
:
Re: String Format rows
Options
Subscribe to RSS Feed
Mark Topic as New
Mark Topic as Read
Float this Topic for Current User
Bookmark
Subscribe
Mute
Printer Friendly Page
All community
This category
This board
Knowledge base
Users
Products
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Anonymous
Not applicable
2015-03-19
07:13 AM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
String Format rows
Hi Guys,
I have a small function to achieve i.e, I want add leading Zero's to the input which have Long as Datatype:
Output:
0000007865
0002333342
0022373461
0000236327
Input:
7865
2333342
22373461
236327
Labels
(2)
Labels
Subscribe by Topic:
Talend Data Integration
v5.x
Ditto - same here!
All forum topics
Previous Topic
Next Topic
«
Previous Replies
1
2
Next Replies
»
12 Replies
Anonymous
Not applicable
2015-03-24
01:52 AM
Author
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
Thanks bhanu chandar
Anonymous
Not applicable
2015-03-24
01:57 AM
Author
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
this one is simple which was suggested by bhanuchandar: Var.var1!=""?("0000000000"+Var.var1 ).substring(Var.var1.length()):""
Output:
Anonymous
Not applicable
2015-03-24
02:05 AM
Author
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
Good solution bhanu.
Post Reply
«
Previous Replies
1
2
Next Replies
»
Tags
talend
java
studio
tmap
Talend Studio
archive
etl
excel
json
rest
tfileArchive
tfilelist
tXMLMap
xml
zip
335544421
Amazon DynamoDB
api
autocommit
aws.util.Base64- JAXB
View All ≫
Community Browser
Forums
Data Integration & Quality
Qlik
Qlik Application Automation
Catalog and Lineage
Qlik Cloud Data Integration
Qlik Compose for Data Lakes
Qlik Compose for Data Warehouses
Qlik Gold Client
Qlik Enterprise Manager
Qlik Replicate
Talend
Move to Cloud
Stitch
Pipeline Designer
Design and Development
Installing and Upgrading
Data Quality, Preparation & Stewardship
Data and Metadata Governance
Deployment
Administering and Monitoring
Component Development
掲示板
Analytics
New to Qlik Analytics
Move to SaaS
Alerting
App Development
AI/ML
New! Qlik Answers
Qlik AutoML
Insight Advisor
Forums by Product
Products (A-Z)
Groups
Industry and Topics
Location and Language
Leader