combine two line items

I have two line items that are addressed to the same list but each one stores a value. that is, in lineitem1 there are some countries in lineitem2 there are countries that do not appear in lineitem1. I need to combine lineitem1 and lineitem 2 into lineitem3. How can this be done?

Accepted answers

rob_marshall

@CarlosRod

So, if I am understanding you correctly, which I am not sure of, your formula on Region Def would be:

if isblank(By Region) then 'R1 - Region' else By Region

All comments

rob_marshall

@CarlosRod

Can you share a screenshot of this as I am not quite understanding the ask...Also, are you using TextList by chance? If so, it is advised not to use that and instead follow this, check out the replies from myself as well as David Smith as to why TextList should not be used..

https://community.anaplan.com/t5/Anaplan-Platform/Lookup-Sum-and-Textlist-Cheat-Sheet/td-p/53085

Rob

CarlosRod

the idea is that in 'Region Def' you place what is in 'By Region' or what is in 'R1- Region' depending on where the value is.

rob_marshall

@CarlosRod

So, if I am understanding you correctly, which I am not sure of, your formula on Region Def would be:

if isblank(By Region) then 'R1 - Region' else By Region

CarlosRod

Yes this is the solution thank you.

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…