Selecting last 10 characters from a field of 20 characters
I'm extracting the 'External Reference' from the Internal Order master data into BI. This External Reference field is 20 char field in ERP. However, the first 10 characters for some of the rows is just zeroes.
In BI, the field which stores this value is 10 characters.
The issue is if External Reference in ERP is '00000000000200012345', then by default it gets saved as '0000000000' in BI. I would want to take the last 10 characters instead, which will be '0200012345'. Please note that it has one leading zero and I would want it this way.
Could you plese advice how to achieve this in the transformations?