The QTY column with integer datatype of length 7 the non significant spaces on the left must be replaced zeros.
If the incoming value is 388, the ouput should be 0000388.
I have used the follwing thing in transformer but its not working
Right(Str("0",7):Trim(Out_Agg.QTY),7)
How to go about it.
Thanks in advance
Amreesh
non significant spaces,on the left must be replaced zeros
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Tue Aug 26, 2008 5:07 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Fmt() is not available in parallel jobs. Had you bothered to Search you would have discovered that it's even easier than your "solution". Assuming you require a seven-character wide result with leading zeroes, use something like The inner parentheses are not actually needed.
Code: Select all
Right(("0000000" : OutAgg.QTY), 7)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 15
- Joined: Tue Aug 26, 2008 5:07 am
Hi ,ray.wurlod wrote:Fmt() is not available in parallel jobs. Had you bothered to Search you would have discovered that it's even easier than your "solution". Assuming you ...
Can you please provide me the solution , it will be a great help
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: