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

[Nivedita R]

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

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

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

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

[Stiltsoft support · Accepted solution]

Hi @Nivedita R ,

Indeed as @Tomislav Tobijas _Koios_ 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.

[Nivedita R]

Hi @Stiltsoft support 

I have a table with Jira Project Link,  Scrum team name,  Scrum Master at mentioned name.  

J1  T1 at-S1
J1  T2 at-S1
J1  T3 at-S2
J1  T4 at-S2
J2  T1 at-S1
J2  T5 at-S3

I want to get 

J1       T1 /n T2 /n T3 /n T4         at-S1  /n  at-S2

J2        T1 /n T5                           at-S1  /n  at-S3


I am not getting a distinct list of formatted i.e., at-mentioned names.  Kindly help with this. 

[Stiltsoft support]

Hi,

The functions work as expected: DISTINCT works with mathematical functions but the formatting is ruined and the automatically aggregating functions don't recognize it.

You may take the Pivot Table macro instead: 

• Set 'Jira Project Link' as Row labels
• Set 'Scrum team name', 'Scrum Master' as Calculated columns
• Choose 'Literal' operation type
• Go to the Options tab and set the Literal value delimiter as \n

It should do the trick. 

[Tomislav Tobijas _Koios_ · Accepted solution]

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