justdream
09-29-2013, 02:00 PM
Dears,
how to automatically Re-Arrange all Data in Input based on Flag (Type) to be as in Output
Input
Output
Flag Name
Type
Flag Name
Type
(A1A)1
Normal
(A1A)1
(A1A)2
(A1A)2
Normal
(A1A)1
(A1A)3
(A1A)3
Normal
(A1A)2
(A1A)1
(B2B)1
Special
(A1A)2
(A1A)3
(B2B)2
Special
(A1A)3
(A1A)1
(B2B)3
Special
(A1A)3
(A1A)2
(B2B)1
(B2B)1
(B2B)1
(B2B)2
(B2B)1
(B2B)3
(B2B)2
(B2B)1
(B2B)2
(B2B)2
(B2B)2
(B2B)3
(B2B)3
(B2B)1
(B2B)3
(B2B)2
(B2B)3
(B2B)3
Idea of my output:
if Type is normal so (A1A) will be connected to all its family (1 is with 2 & 3) (2 with 1 & 3) and (3 with 1 & 2)
if Type is Special so (B1B) will be connected to all its family Plus itself (1 is with 1 & 2 & 3) (2 with 2 & 1 & 3) and (3 with 3 & 1 & 2)
Your immediate support it highly appreciated
how to automatically Re-Arrange all Data in Input based on Flag (Type) to be as in Output
Input
Output
Flag Name
Type
Flag Name
Type
(A1A)1
Normal
(A1A)1
(A1A)2
(A1A)2
Normal
(A1A)1
(A1A)3
(A1A)3
Normal
(A1A)2
(A1A)1
(B2B)1
Special
(A1A)2
(A1A)3
(B2B)2
Special
(A1A)3
(A1A)1
(B2B)3
Special
(A1A)3
(A1A)2
(B2B)1
(B2B)1
(B2B)1
(B2B)2
(B2B)1
(B2B)3
(B2B)2
(B2B)1
(B2B)2
(B2B)2
(B2B)2
(B2B)3
(B2B)3
(B2B)1
(B2B)3
(B2B)2
(B2B)3
(B2B)3
Idea of my output:
if Type is normal so (A1A) will be connected to all its family (1 is with 2 & 3) (2 with 1 & 3) and (3 with 1 & 2)
if Type is Special so (B1B) will be connected to all its family Plus itself (1 is with 1 & 2 & 3) (2 with 2 & 1 & 3) and (3 with 3 & 1 & 2)
Your immediate support it highly appreciated