Keeping the length of the record constant

RaghuMulki

I am looking for a solution to keep the length of the record constant to 10 digits.

For ex if I have 7 records like this 1) 1234567

2) 123456

3) 12345

4) 1234

5) 123

6) 12

7) 1 Then I need to achieve 1) 0001234567 2) 0000123456 3) 0000012345 4) 0000001234 5) 0000000123 6) 0000000012 7) 0000000001.

I can achieve this in excel by using REPT function but looking for solution in Anaplan. Any help greatly appreciated.

Capture.PNG

Accepted answers

rob_marshall

@RaghuMulki

Give this a try:

right("00000000"&line item,10)

Ashutosh

@RaghuMulki,

Follow the same mentioned by Rob
Jsut give try by using like "D" & right("00000000"&line item,10)

All comments

rob_marshall

@RaghuMulki

Give this a try:

right("00000000"&line item,10)

RaghuMulki

Thanks for looking into my request @rob_marshall above formula might help me to think in a different way to meet my requirement.

But my actual requirement was, suppose If i have the records like 1) 1, 2) 12, 3) 123, 4) 1234 then I need to achieve 1) D000000001 2) D000000012 3) D000000123 4) D000001234 etc.

Sorry for not making clear in my earlier post.

Thanks

VIGNESH.M

@RaghuMulki , first identify the length of the record and then add the zero's in the prefix for the remaining character.

Ashutosh

@RaghuMulki,

Follow the same mentioned by Rob
Jsut give try by using like "D" & right("00000000"&line item,10)

RaghuMulki

Thanks everyone. we could able to achieve by using the solution suggested by Rob and Ashutosh

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…