I have a requirement where, i have a source column from which i am getting two types of records which are numeric and alphanumeric which is defined as Varchar field in the DS job.
Now my requirement is, if a record with all numeric characters comes, the preceding zeros should be deleted.
if a record with alphanumeric characters comes, the preceding zeros should be preserved.
So, this requirement is for the records prepadded with zeros.
Can it be achieved for the same column?
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
![Exclamation :!:](./images/smilies/icon_exclaim.gif)