Concatenate multiple items
I'm slightly confused on the best approach to concatenate multiple items into a single text line item (where neither is a code or part of a list)
For example lets say I have a module with the following line items
T1, T2, T3, T4, T5, T6 and T7 and Concat line item is C1
Currently C1 shows: T1 & "_" & T2 & "_" & T3 & "_" & T4 & "_" & T5 & "_" & T6 & "_" & T7
Based on my understanding that I should break this up into smaller chunks among multiple line items. For example
New 1: T1 & "_"
New 2: T2 & "_"
New 3: T3 & "_"
New 4: T4 & "_"
New5: T5 & "_"
New6: T6 & "_"
For the above I did read, it's preferred to use:
New 1: is isnotblank(T1) then T1 else blank
(Since T7 doesn't have a "_" afterwards, no need to recreate the same line)
Next would be to start creating small concats with the first group of new lines
New10: New1 & New2
New11: New3 & New4
New12: New5 & New6
New20: New10 & New11
Updated C1: New20 & New21.
Multiple Boolean Line Items (B1 - B20) and Combined Text (C1)
C1: If B1 then "T" else "F" & "|" & if B2 then "T" else "F" & "|", etc
Would this follow the same as my first example
Would this be the correct approach? What I'm confused about is when I look at example of the best ways to concate, they all seem to reference multiple "code" line items and a system module should be created and that new module referenced.