Find out all the groups in a data.

Database
Enthusiast

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 (1)
5 REPLIES
Enthusiast

Re: Find out all the groups in a data.

Barani,

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

Khurram
Enthusiast

Re: Find out all the groups in a data.

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

Enthusiast

Re: Find out all the groups in a data.

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
Enthusiast

Re: Find out all the groups in a data.


@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
Enthusiast

Re: Find out all the groups in a data.

Any1??