Data from different columns in a single column in different lines in a Table

Technical queries
#1

Hello Helical Team,

I am using Helical Insight 4.0. I have a table in which I have the name, address and phone number. I want to show them as below:

image

I tried using concat, but it shows all the values in a single line. Is there a way I can get the above view?

Thank You,
Jam.

#2

Hello Jam,

You can create a custom column with the formula similar to one shown below:

(‘Name:’||employee_details.employee_name||’<br>’||’City:’||employee_details.address||’<br>’||’Type: ’||travel_details.travel_type)

Note: Modify the column names and text as per requirement. The syntax differs from database to database and will need to be modified accordingly.

Here, the
tag is used to go to the next line. Basically the table understands the HTML tags which we are using. The output of the above code would be as below:

image

Thank You,
Helical Insight.

#3

hey, so where to type this html code? i want to combine first name and last name in one column for my tabular report in helical. how can i do that?

#4

Hello Shikha,

You don’t have to write HTML code for combining First Name and Last Name. Rather you can create a custom column and within custom column, you can write CONCAT function. Check the relevant concat function syntax for your database from internet. Then apply the same into custom column something like :

CONCAT (firstcolumnName, ’ ', lastcolumnName)

For how to create custom column refer : Custom Column - Helical Insight

Thank you