Putting values in territory field from multiple quota assignment rows of an employee into one field

CommunityMember96641

Hi Experts,

Appreciate your brainpower on below challenge.

Using below test employee as an example, we would like to have a field show “PKI, BCT” in the same row same cell, similar to concatenate or textjoin in excel.

Expected result like below (using excel as demostration)

Thanks a lot!

HimanshuRaj

Hi @CommunityMember96641

It's not clear what you want to achieve in Anaplan. Could you share what logic you used in excel to get “PKI, BCT” concatenation?

In anaplan also, you can use text concatenation to achieve this but want to make sure how you are getting PKI, BCT in 1st row in excel.

Thanks

Arnab116

Hi @CommunityMember96641,

You can explore the TEXTLIST Function to achieve your requirement.

https://help.anaplan.com/c1e24970-400f-43af-95e7-b34a43253cdb-TEXTLIST

You can use this function to get all the territories an employee in assigned to in a single cell.

Let me know if you find any difficulty in implementing this.

Hope this helps,

Thanks,

Arnab

CommunityMember96641

Thank you Arnab and Himanshu!

I used “Values to list[TEXTLIST: Mapping, TEXTLIST: Mapping 2, etc.]” to sum to another module and it worked!!!