How to put an expression to find ID shared by multiple group and region ?

[prahlad_infy]

Hello Sirs,

I have two requirement from a simple data :

1)  View something like (expression to find ID shared by multiple group and region)

ID	GROUPS WHICH SHARE SIMILAR ID	REGION WHICH SHARE SIMILAR ID
ID1	7 , 10	EUR , PAFAC
ID2	12 , 16	US , EUR

2) User based identification (parameterised condition) using input box 

I have created an input box with values 2 to 10 .

If user selects 2 then , i should get yield me list of Group whose id is shared by two different groups 

If user selects 3 then , i should get yield me list of Group whose id is shared by three groups groups 

SOURCE DATA

GROUP	REGION	ID
1	AMENA	ID9
1	AMENA	ID11
2	PAFAC	ID7
2	PAFAC	ID12
3	EUR	ID8
3	EUR	ID18
4	US	ID6
4	US	IDC1
5	AMENA	ID4
5	AMENA	ID22
6	PAFAC	ID3
6	PAFAC	ID44
7	EUR	ID1
8	US	ID6
9	AMENA	ID6
10	PAFAC	ID1
11	EUR	ID3
12	US	ID2
13	AMENA	ID8
15	PAFAC	ID5
16	EUR	ID2
16	US	IDC1
17	AMENA	ID4
18	PAFAC	ID7
18	US	IDC1
19	EUR	ID3
20	US	ID6
21	AMENA	ID9
22	PAFAC	ID3
23	EUR	ID7

Thank you 

[prahlad_infy]

@tresesco 

@marcus_sommer 

@sunny_talwar 

Please help . You guys have given help to me earlier .

[DavidM]

How about adding counted field to your script:

Load

ID,

Count(ID) as ID_Count,

resident SourceData

Group by ID;

You can create the filter with field ID_Count which will show you the ID's you need (you decide whether to Map or Join the table with Count, or leave it as it is)