Uses for TEXTLIST

ChrisHeathcote
Community Boss

Uses for TEXTLIST

Hi All, 

I am unsure where I might use TEXTLIST function. 

There has never been a need for me to use this but I would like to understand where, when and how this might be useful.

Your insights are much appreciated!!

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
1 ACCEPTED SOLUTION

Accepted Solutions
rob_marshall
Moderator

Re: Uses for TEXTLIST

@ChrisHeathcote 

 

Please DON'T use TextList().  Folks used Textist() instead of using FirstNonBlank/LastNonBlank but if you look at this thread, there are ways around it.

 

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

 

Rob

View solution in original post

2 REPLIES 2
rob_marshall
Moderator

Re: Uses for TEXTLIST

@ChrisHeathcote 

 

Please DON'T use TextList().  Folks used Textist() instead of using FirstNonBlank/LastNonBlank but if you look at this thread, there are ways around it.

 

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

 

Rob

View solution in original post

ChrisHeathcote
Community Boss

Re: Uses for TEXTLIST

Thanks @rob_marshall for pointing me in the right direction. 

 

I had to ask as I couldnt see a clear use case for the TEXTLIST and I can see that we are strongly advised to NOT use it which was my instinct all along. 

 

The case for being able to reverse the LOOKUP while it appears useful is achievable using a more effective and less performance sapping technique.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA