Concatenate users into a text field

Highlighted
Occasional Contributor

Concatenate users into a text field

Hello,

I created a matrix, including two lists (tasks list and the built in users list) as dimensions and a boolean formatted line item in order to set write access for an other line item through the Write Access Driver. That part works, no issue with it.

But I want to list (concatenate) in a simple text formatted line item all the users who have been previously marked (through the booleans described above). Is there a way to this? So, as an output I'd like to see my tasks list and a line item including all the users.

The purpose is that every task in the tasks list might have several users with write access, and I want to list all users in one field who will have write access for each given task in the list.

 

13 REPLIES 13
Highlighted
Community Boss

Re: Concatenate users into a text field

Hi,

to concatenate lists items into text we use the function TEXTLIST.
I have not tested it with the user list though, expecting your results 🙂

Nathan Rudman, Anaplan Model Builder
Highlighted
Frequent Contributor

Re: Concatenate users into a text field

Hello,

 

TEXTLIST function cannot be used with USERS list. Its one of the constraint with TEXTLIST. 

May be you can create custom users list and use textlist function.

 

Harsha_D_0-1588775770495.png

Thanks,

Harsha

Highlighted
Frequent Contributor

Re: Concatenate users into a text field

Hello, 

 

I have created custom user list and I got below results. Let me know if this what you wanted.

 

Source Module:

Harsha_D_0-1588776783793.pngHarsha_D_1-1588776813747.png

 

Target Module:

Harsha_D_2-1588776844570.png

Harsha_D_3-1588776866699.png

 

Thanks,
Harsha

 

 

Highlighted
Community Boss

Re: Concatenate users into a text field

learnt two things today:
- textlist doesn't work with Users
- read the doc I should

Nathan Rudman, Anaplan Model Builder
Highlighted
Master Anaplanner/Community Boss

Re: Concatenate users into a text field

@zsitvayb 

 

See if this helps

 

Step 1: Create a Fake Users list. This list will be pulled from System module of Native Users

Step 2: Create a module with Task List and Fake Users as dimensions and  two line items created as well.One Boolean and other Text 

           Boolean for Input

           Text for identifying the user

 

Misbah_1-1588776978553.png

 

Step 3: Create another module with Just Task List as a dimension and one text formatted line item

Misbah_0-1588776943281.png

 

 

Highlighted
Occasional Contributor

Re: Concatenate users into a text field

Thanks, this seems to be something I tried. I think I failed because of using the system user list in the textlist function.

Maybe, it's just too late for me and it should be obvious, but can you please elaborate a bit your below point of 

 

'Step 1: Create a Fake Users list. This list will be pulled from System module of Native Users'

 

I assume a fake users list that is being somehow synchronized with the native users list, but have no idea how to do it.

Highlighted
Master Anaplanner/Community Boss

Re: Concatenate users into a text field

@zsitvayb 

 

I called it Fake you can call it anything, Fake Users list is when you try to mimic the Native Users List. So how to create Fake Users list

 

Step 1: Create a System module with Users list as a dimension. Create one line item and get the Users by writing formula  ITEM(Users) in the line item.

Step 2: Create a list call it anything and Import the Users from System module of Users (Created in Step 1).

 

Your Fake User list is ready

Highlighted
Occasional Contributor

Re: Concatenate users into a text field

Thanks, that was clear. I just thought there is a way to have the fake list automatically sychronized with the native list instead of importing it from the module.

But then will try it out soon. 

Highlighted
Occasional Contributor

Re: Concatenate users into a text field

@Misbah

 

Sorry, one additional question:

If I use the fake user list, then how can I use this module to drive the write access for a line item?

I have no idea how to use the value of the boolean here that is linked to the task list/dummy user list in a module where I have the task list/native user list as dimensions.