Any alternative for the TEXTLIST() function?

aykcos

Hi all,

 

The use of the TEXTLIST() is not a best practice. However, as I go through the Anapedia, Planual and forum threads I haven't seen the alternative for that. There are some forum threads that provide ANY, FIRSTNONBLACK, LASTNONBLACK as alternatives for the TEXTLIST[], which is aggregation function. But I need alternative to the TEXTLIST() function, which is a TEXT function, not an aggregation function.

 

I'd appreciate your replies? Thanks in advance.

aykcos

Hi @KirillKuznetsov ,

Thanks for your reply. IF 'SYS57 Territory FL'.Code = CODE('???QCALC08 Account Coverage Report'.Territory Assignment) THEN TEXTLIST('???QCALC08 Account Coverage Report'.Portfolio Text List, ", ", 'P4 Portfolio Group') ELSE BLANK

For example the formula that I am trying to optimize is TEXTLIST(Module A.Line Item B, ",", 'List C') . What I'd like to know is, is there a alternative way to get the same result?

Thanks in advance.

aykcos

Here is the blueprint view of the target module.

And here you can find the blueprint view of the source model.

 

I really appreciate your help Kiril.

Thanks.