Rename List items

Highlighted
Super Contributor

Rename List items

Dear Friends,

 

I need some help from you.

I want to update my list.

 

My initial list items (12 list items), will be renamed and a new list will created with the (4 list items).

 

Sravan_Kumar_0-1592830473321.png

 

 

 

11 REPLIES 11
Highlighted
Regular Contributor

Re: Rename List items

@Sravan_Kumar 

 

Hi,

Can you provide more clarity as to what you need, do you need to reload the list with the new items or in the existing list, create a subset and aggregate count based on same name?

 

 

Highlighted
Super Contributor

Re: Rename List items

Hi @Kanishq17,

 

No, not a subset.

It will be renamed.

Orange1 remains Orange1

Orange2 becomes Orange1

Orange3 becomes Orange1.

 

You can see the sales count.

It will help for better clarification.

Highlighted
Regular Contributor

Re: Rename List items

@Sravan_Kumar 

If it is a general list , Orange2 cannot become Orange1 as duplicate entries are not allowed, so you can only keep the 1 entries, then delete remaining items and change the count in the source file and then upload again

Highlighted
Regular Contributor

Re: Rename List items

You can create a action to delete the list using delete using selection action, in the boolean you specify which list items you wish to delete and then reupload the file with the new items, if you load the new file, anaplan will update the count for matching items and not delete the existing list

 

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Other_Actions/Delete_from_...

 

This will help you

 

 

Highlighted
Super Contributor

Re: Rename List items

This is not the correct answer.

 

My question was to rename the list members with an existing list name.

Highlighted
Regular Contributor

Re: Rename List items

@Sravan_Kumar , 

But you need count to be aggregated , so instead of keeping multiple , use only 1 item 

Highlighted
Super Contributor

Re: Rename List items

I think we can do it by SUM function.

Highlighted
Regular Contributor

Re: Rename List items

For using SUM,

create another list with only items you need i.e ones and in that module create a ine item list formatted to the new list and then establish mapping , then in the target use count[sum:mapping],

But this will require a new  list 

Highlighted
Regular Contributor

Re: Rename List items

Anyways In case you need to have multiple items with same name, you need the list to be a numbered list and keep a display name property which will allow you to rename items