same id different name

[gauthamchilled]

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

[Chanty4u]

try

Dim: ID

EXP:=sum({<Id=p($(=Id={'100,'200'}))>}Id)

[gauthamchilled]

there are many ids that may be duplicated, so am not sure about that. then how can i use in set analysis???

[#4]

You can use If(Aggr(Count(ID),ID)>1,ID)..

Thanks,

Nandu.

[PrashantSangle]

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,

[raju_insights]

Hi Gautham Prasad,

You can use calculated dimension.

If(Aggr(Count(ID),ID)>1,ID)

PFA.

[miguelbraga]

Hey there,

See my attached file

I think this is what you want!

Regards,

MB

[sunny_talwar]

Another way:

Dimension:

ID,

Name

Expression:

If(Count(DISTINCT TOTAL <ID> Name) > 1, 1)

and then you can safely hide the expression