Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table data like below
ID,Name,
100,ABC
200,DEF
100,XYZ
212,FGH
200,DDD
300,MHN
I want to show the following with result in a straight table..same id but different name
output
100,ABC
100,XYZ
200,DEF
200,DDD
how can i get this
try
Dim: ID
EXP:=sum({<Id=p($(=Id={'100,'200'}))>}Id)
there are many ids that may be duplicated, so am not sure about that. then how can i use in set analysis???
You can use If(Aggr(Count(ID),ID)>1,ID)..
Thanks,
Nandu.
Hi,
In Script try like
Temp:
LOAD * INLINE [
ID,Name,
100,ABC
200,DEF
100,XYZ
212,FGH
200,DDD
300,MHN
];
NoConcatenate
T1:
Load count(Name) as cName,ID
Resident Temp
group by ID;
Final:
Load ID
Resident T1
where cName=2;
Left Join
Load * Resident Temp;
Drop Table T1,Temp;
Regards,
Hi Gautham Prasad,
You can use calculated dimension.
If(Aggr(Count(ID),ID)>1,ID)
PFA.
Hey there,
See my attached file
I think this is what you want!
Regards,
MB
Another way:
Dimension:
ID,
Name
Expression:
If(Count(DISTINCT TOTAL <ID> Name) > 1, 1)
and then you can safely hide the expression