0

How to format the column so that it adds leading zero to a column value. for example , in the etext template i want to add this logic. using which function can i do this ?

that is if job_code is 2900 then it should come as 002900. I tried adding "0000000" under the format column, but it didnt work.

SSA_Tech124
  • 577
  • 1
  • 9
  • 25

1 Answers1

0

You could format the column in Data Model sql so it comes to the template already formated.. Select LPAD(COLUMN_NAME, 6, '0') as ALIAS... Here is an example of LPAD function: ERROR: Function SUBSTR requires a character expression as argument 1. and adding zeroes in front of data

d r
  • 3,848
  • 2
  • 4
  • 15