All Forums Database
barani_sachin 141 posts Joined 01/12
07 Jan 2014
Find out all the groups in a data.

Hi All,
 
Here i have to find out the Groups. Group meaning they shud have called the people in that group only.
 

Name

From Number

To Number

AAAA

1

3

BBBB

2

7

CCCC

3

1

DDDD

4

5

EEEE

5

4

FFFF

6

5

GGGG

7

2

FFFF

6

4

 
In the above dataset the groups would be
 

Name

From Number

To Number

AAAA

1

3

CCCC

3

1

 
 
 

Name

From Number

To Number

BBBB

2

7

GGGG

7

2

 
 
 

Name

From Number

To Number

DDDD

4

5

EEEE

5

4

FFFF

6

5

FFFF

6

4

 
 
Thanks in advance.
 
 

Tags:
M.Saeed Khurram 544 posts Joined 09/12
08 Jan 2014

Barani,
Your dataset is confusing, Do you want to find groups based on common To_Number and From_Number?
 

Khurram

Raja_KT 1246 posts Joined 07/09
08 Jan 2014

Sachin,

I feel you can put the input and output data in tabular format using code , given in format bar. The last part of the data is not clear. It seems that anyone who makes calls from and to. Also, last part FFFF(6,5) and F(6,4) does it mean that calls are made from D and E respectively?

If you read from the same table twice, with case when statement , maybe you can you get.

 

Cheers,

Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

barani_sachin 141 posts Joined 01/12
08 Jan 2014

Sry guys for the trouble, ma bad will post it in a readable format.
Here i have to find out the Groups. Group meaning they shud have called the people in that group only.
 
 

Name  From_Number To_Number
AAAA 	1 		3
BBBB 	2	 	7
CCCC 	3		1
DDDD	4 		5
EEEE 	5 		4
FFFF 	6 		5
GGGG 	7 		2
FFFF 	6 		4

In the above dataset the groups would be
 

Group 1

Name  From Number To Number
AAAA 	1 		3
CCCC 	3 		1



Group 2

Name  From Number To Number
BBBB 	2 		7
GGGG 	7 		2


Group 3

Name From Number To Number
DDDD 	4 		5
EEEE 	5 		4
FFFF 	6 		5
FFFF 	6 		4


 
 

barani_sachin 141 posts Joined 01/12
08 Jan 2014

@M.Saeed Khurram, Yes i want to find out the common groups

@Raja_KT, It means that FFFF has made calls to DDDD & EEEE

From Number is the number of the caller (Ex 1 is the Number of AAAA and it will always remain the same)

Thanks,
Barani

barani_sachin 141 posts Joined 01/12
09 Jan 2014

Any1??

You must sign in to leave a comment.