Table Transformer: How to include DISTINCT with CONCAT_VIEW_AGGR & FORMATWIKI?

Question

I want to include only distinct teams in the current query which aggregates the teams

CONCAT_VIEW_AGGR(FORMATWIKI(T1.'Team', " 
")) AS 'Teams',

---
The formatting is retained but duplicates are present -- CONCAT_VIEW_AGGR(FORMATWIKI(DISTINCT T1.'Scrum Coach', "
")) AS 'Scrum Coaches1',

The duplicates are not there but the formatting is lost. 
SUM(DISTINCT T1.'Scrum Coach' + "; ") AS 'Scrum Coaches',

Tomislav Tobijas · Accepted Answer

Hi @Nivedita R ,

I'm guessing this is a specific Marketplace app to which your question is related.

I would suggest reaching out to vendor support team with this request as they can probably give you advanced assistance on the matter.

Usually, Marketplace apps have 'Support tab' on their app listing from which you can find links or email(s) for creating support ticket.

Cheers,
Tobi

Stiltsoft support · Accepted Answer

Hi @Nivedita R ,

Indeed as @Tomislav Tobijas has kindly mentioned, you may refer to our support directly (the Table Transformer macro belongs to the Table Filter, Charts & Spreadsheets for Confluence app). Here we find the related questions manually and there everything is registered, besides the support portal is confidential.

What concerns your use case, you may try to use internal&external SELECTs: in the internal SELECT you use the DISTINCT function and leave only the unique rows, in the external SELECT you apply the FORMATWIKI function (or do whatever you need with these unique rows). The structure will look as following:

SELECT *

FROM (

SELECT * FROM T1)

Please note that in the external SELECT you van use only column names without the T1. prefix (in the external SELECT we work with an already modified table, so it is not the original T1 table).

Or you may do the same using two Table Transformer macros one on top of the other.