Show Distinct String values in Straight table ?

[#1]

I have string based column field with many duplicate values. I wish to show only the Distinct or unique values. sounds simple or is it?

I tried Concat(DISTINCT Name)   aslo Only()  none have worked.  Please help.

The reason why I need to use a Straight table is the need to show dates side by side.

Thank you all.

[chematos]

Have you tried this in an object text?

=concat(distinct Name, ',')

Regards

[#3]

Correct it works in a Text object.

But wont in a Table expression. I was trying to show the tasks one row at a time vs comma sepreated, but maybe thats the only way. The =concat(distinct Name, ',')  will display but doenst remove the duplicates when used in a straight table expression.

[chematos]

Maybe using a pivot table...

The problem is the opening of that field, to get one row you need to have an opening of 1 result for each dimension...

I would try with Firstsortedvalue() or using an aggr() function with the dimension as the group of the aggregation

[#5]

Ok, I will give those functions a try. Thanks

[#6]

The reason I forgot to mention for having a table is dates are associated with the Name.

QV doesn't seem to have many string functions that handle Tables well.