Please, someone could help me to desconcatenate if it is possible the flat list and if not a module
Thank you so much
Hi @Jamez ,
You can use Left, Right function of anaplan to de-concatenate this string.
For example: Left(Concatenate, 4) = 9280
Hi @Umang Singhal
I know, my problem it´s to de-concatenate the three parts in three line items into a module
9280-1314-31:D1347- Non PBH
And each line are differents, at you can see the 3º line has 5 characteres and the firs one only four
what is your line separator? If it is Colon (|) ?
@Jamez, Instead of giving static parameters in the left, right, and mid functions, make them dynamic based on the separator (Colon (I)). Let's say your separator is Colon so a line item with formula like FIND("|", Concatenate) will give you the number of characters before first colon and then use this line item in your LEFT function to make it dynamic. Try it out and let me know if it's not clear, I'll build and share in some time.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
