Is there any easy way to replace a Line Item in the whole model in all formulas? right now i have to check hundreds of modules to switch out a Line Item, which is quite tedious
//GP
Hi @GP , 1 of the ways is to copy the entire line items tab to an excel, find & replace your line item and then paste it back. It might need some work in the excel to add the ' before and after the formula but would also save you considerable amount of time. If your line item is generic & present in multiple modules with the same name then you could just rename it for this task to something very unique (both source & target line items) and then after the exercise rename it back to what it was. Hope this helps! :)
yes multiple modules, hundreds..and no, the line item is referred in other formulas in other module line items, its not just doubled by name and content. At least i could use the internal replace function (Ctrl+H) in the formula editor in anaplan, this helped its not just renaming. i want to use another (a new one) Line Item which replaces the old one, and the old should remain im already done - did it manually, but im sure i need to do this again somewhen
@GP - Yes, you could copy this tab to an excel and lets say in this example I want to change the line item "Mapping" to "Mapping new" in the entire model wherever it exists. Copy paste this tab into an excel, do a find & replace for mapping to mapping new & copy back the result.
This way all the formulas referring to mapping earlier now refer to mapping new.
i didn't dare to paste the full line item collumn π
Can someone help me i am unable to login anaplan portal using my credentials
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to getβ¦
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made toβ¦
