Hello, I need to convert this number formatted line item to 04/11/2022. Best approach?
Hi @melliott ,
First you need convert number to text
second you need to break data to day, month, and year
third you need to convert data (day, month, year) to DATE
Here the Blueprint
Regards,
Panji
How does this number come in to Anaplan?If it is imported in you could convert to date during import (assuming it comes with a leading zero, 04112022).
Hi @melliott,
I assume it's always imported as an 8-digit number, with all leading zeros included (so it's unambiguous that i.e. 1112022 is 1/11/2022, and 11/1/2022 would be 11012022). Also in my answer I assume format MMDDYYYY, and I do conversion just on numbers (without converting back and forth to text):
Blueprint:
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…
