Home Analytics Designing reports
The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

Make a new line from Concat aggregation?

<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>

    Pierre Richer

    Solutions Consultant, Analytics & Reporting

    OpenText

     

Sign In or Register to comment.