duplicate & Unique

[shiveshsingh]

I have two columns,

Name, Salary

a,1

b,3

a,2

a,4

b,6

d,7

From these, i want below output. Not like attached

Duplicate, Unique

a               d

b          

[antoniotiman]

Hi,

see Attachment.

Regards,

Antonio

[m_woolf]

Try this:

[effinty2112]

Hi Shivesh,

=Concat(Distinct Aggr(if(Count(Name) > 1,Name),Name),', ')

returns

a, b

=Concat(Aggr(if(Count(Name) = 1,Name),Name),', ')

returns

d

Cheers

Andrew

[shiveshsingh]

not able to open qvw file, can you show expression & dimension

[antoniotiman]

Script :

LOAD * Inline [
Name, Salary
a,1
b,3
a,2
a,4
b,6
d,7
];

Table (Pivot)

Dimension :  =Aggr(If(Count(Name) > 1,'Duplicate','Unique'),Name)

Expression :  Concat(DISTINCT Name,Chr(10))

and