I have a columns which is an integer and I want to make it consistent length of 13 and append leading zeroes to make it 13.
Secondly I also want to make sure that the first three places are 001 followed by some leading zeroes and then the number.
9894567 - Output should be 0010009894567
123567891 - Output should be 0010123567891
So there are definitely several ways you can accomplish this through DSS!
If you are a "coder", then one option would be to use Python or R via a code recipe to read the dataset into a data frame and then use code to handle the transformation that you need:
However, for the sake of argument, let's say that you are not a "coder" but a "clicker" instead. You can still accomplish this by utilizing various processors through a Prepare recipe, which I will walk through below.
I hope this example proves helpful and please keep in mind that you might need to adjust or add steps/processors/formulas as necessary depending on your particular use case. As mentioned earlier, this just illustrates one way this can be done using non-coding options that can be found in DSS. If you are a data scientist or a coder, then there is always the option to write your own code instead via a code recipe! 🙂