Table Transformer Macro: how to remove duplicates attributes in different rows

silvio croce

Hello,

I need to remove duplicates from a table that I created getting issues from jira using the table transformer macro.

for example if I have a table like this:

 

colun1 | column2 | column3

1          | 2             |3

1          | 2             |4 

5          |  6            | 7

 

Should be transformed into:

 

colun1 | column2 | column3

1          | 2             |3

            |                |4 

5          |  6            | 7

 

Of course I need all of this to be dynamic and not custom to a particular table.

 

Thanks in advance

Katerina Rudkovskaya _Stiltsoft_

Hi @silvio croce,

The simplest way to aggregate tables is to use the Pivot Table macro:

And here is another variant using the Table Transformer macro:

SELECT 'column1', 'column2',
CONCAT_VIEW_AGGR(FORMATWIKI('column3' , "\n")) AS 'column3'
FROM T*
GROUP BY 'column1', 'column2'

Hope it helps your case