2.02-11 Avoid using TEXTLIST()

rob_marshall
rob_marshall
in Planual

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.

Tagged:

Comments

  • lgrady
    lgrady

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

  • rob_marshall
    rob_marshall

    @lgrady

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

Title

Categories