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

Padding with space if required Length is not met

Hi,
I am trying two scenarios.
1. I need to pad with zeros if required length of the field is not met.
I am trying to find out the number of records in the file.. If the length is not 8, I need to add preceding zeros.
2. I need to pad with empty spaces to the string field to make it fixed length format in the report.
If the length of the string is not 30, then I need to do the right padding with spaces and need to check if the field value is coming or not also.. (null or not)

How to achieve the above scnarios through TMap

Labels (2)
2 Replies
Anonymous
Not applicable
Author

I got the answer
Anonymous
Not applicable
Author

Hello,

We will appreciate if you could post the solution here.

Best regards

Sabrina