Make a new line from Concat aggregation?

SailRCG
edited February 11, 2022 in Analytics #1
<p>I am trying to create a new line for each " / " I encounter in an aggregated text string. Basically I have a computed column which puts:</p>
<p> </p>
<p>Col Label 1      |         Col Label 2                   |    Col Label 3 </p>
<p>
</p>
<p>John                |    1PM - 4PM/8PM - 12AM    |     someStuff</p>
<p>
</p>
<p>Alex                 |     9AM - 5PM/                       |     otherStuff</p>
<p>
</p>
<p>Mary                |    10AM - 4PM/7PM - 9PM    |     herStuff</p>
<p> </p>
<p> </p>
<p> </p>
<p>I want it to  look like:</p>
<p>Col Label 1      |         Col Label 2                   |    Col Label 3 </p>
<p>
</p>
<p>John                |    1PM - 4PM                         |     someStuff</p>
<p>                             8PM - 12AM    </p>
<p>
</p>
<p>Alex                 |     9AM - 5PM                        |     otherStuff</p>
<p>
</p>
<p>Mary                |    10AM - 4PM                       |     herStuff</p>
<div> </div>
<p>                               7PM - 9PM    </p>
<p> </p>
<p>I have tried adding <br>, /n, cr, \r\n.... etc... nothing seems to help... my concat is always a concat. </p>
<p> </p>
<p>Any ideas?   </p>

Comments

  • <p>Hi,</p>
    <p> </p>
    <p>You should be able to create a computed column like this one:</p>
    <pre class="_prettyXprint _lang-">
    row["CUSTOMERNAME"] + "\n" + row["CITY"] + "\n" + row["COUNTRY"]
    </pre>
    <p>and use it in a data item to display data on multiple rows:</p>
    <p> </p>
    <p>
    Warning No formatter is installed for the format ipb