Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
see Attachment.
Regards,
Antonio
Try this:
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
not able to open qvw file, can you show expression & dimension
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