How to merge only 1 specific column in 2 rows by using sql?

[Goh]

I have 2 pivot tables (data retrive from JIRA queries) and one normal table which I have to insert the data manually in the 'Cost' Column.
These 3 tables are going to display as one table in the page.

Does anyone know how to merge the rows like this after published the page?

Appreciate your help :)

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Goh,

In general, you may try the following SQL query to group your data:



SELECT FORMATWIKI(SUM('Member' + "\n")) AS 'Member',
'Cost'
FROM T*
GROUP BY 'Cost'



But I really can’t see how it will get along with your case. As I understand, you join all the three tables into one table, so all “members” should be in separate cells for the comparison.

The variant that you’ve shown on the screenshot is not possible at all: if you create a table with merged cells manually and then wrap it in the Table Transformer macro, the cells will be split at once. The macro treats tables as mini databases, so there can’t be any merged cells.