2.02-11 Avoid using TEXTLIST()

rob_marshall

TEXTLIST() requires a lot of memory for calculations and should be avoided if possible, using two dimensional modules and Boolean flags with ANY is a good alternative.  Other alternatives are using FIRSTNONBLANK as well as LASTNONBLANK.

lgrady

Does the same rule apply to TEXTLIST aggregation method or is this specific to the TEXTLIST function?

rob_marshall

@lgrady

Yes, it applies to Textlist in general, both as an aggregation function and a regular function.