Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

how to search for conflict data

12345_abcde12345_abcde Posts: 5Member
[code]1 SEG-AMK EG1832 Mechanics and Materials 286 1.5 EG1832
2 SEG-AMK EG1833 Electrical Principles 375 1.5 EG1833 EG1952 EG1903
3 SEG-AMK EG1835.1 Engineering Mathematics (1) 456 1.5 EG1835 EG1001
4 SEG-AMK EG1835.2 Engineering Mathematics (2) 363 1.5 EG1907 EG1681 EG1951 EGB101 EGC101 EGD101 EGF101 EGH101
5 SEG-AMK EG1004 Analog Electronics 262 1.5 EG1004
6 SEG-AMK EG1009 Electric Circuits 229 1.5 EG1009
7 SEG-AMK EG1010 Digital Electronics 229 1.5 EG1010
8 SEG-AMK EG2008 Engineering Mathematics 2B 563 1.5 EG2008 EG2681 EGB207 EGC207 EGD207 EGF207 EGH207 EGJ207
9 SEG-AMK EG1008 Engineering Mathematics (1A/1C) 570 1.5 EG1008 EGB107 EGC107 EGD107 EGF107 EGH107 EGJ107
10 SEG-AMK EG2010 Electronic Communication 221 1.5 EG2010[/code]

i have an excel file which contains the above.

i have a datagrid and access database which contain the following:

[code]ModuleCodes AdminNo
EG1001 112960A
114424H
120428G
120595K
123452P
124090Q
125559F
125662E
126117Y
126184K
126386A
126387F
126388W
126389J
126390Q
126391K
126394N
126395C
126396P
126397R
126398E
126414K
126417N
126418C
126419P
126423T
126424H
126428Z
126429B
126430U
126431G
126455A
126495S
126501A
126503W
126511P
126514L
130016W
130019K
130020D
130022N
130034B
130036G
130351H
130355Z
130361W
130362J
130368C
130485R
130488T
130516Z
130737P
130787T
130799J
130845J
130856T
131062L
131067M
131076Q
131453L
131485G
131504M
131834J
131838Y
131841P
131893X
131903J
132212L
132873Y
132891W
133430E
133609Y
133882Q
134125S
134127Z
134134J
134390D
134745X
134775A
134781D
134787E
134795B
134870J
134923P
134929X
134930S
134972L
134973T
134974H
134989Y
135009Q
135068S
135078Q
135105N
135107P
135183S
135594T
135598M
135619X
135622Z
135678D
135693U
135715B
135734X
135744J
135754L
135777L
135786G
135789W
135810A
135815K
135835W
135836J
135843P
135916T
135995F
136020J
136027P
136035M
136050P
136056X
136075E
136084U
136086A
136093Y
136107U
136118C
136142P
136175B
136276D
136320Q
136325C
136601C
136683G
136692N
136706G
136744T
136745H
136883H
136884X
136917J
136919K
136922N
136925R
136926E
136929H
136930X
136939W
136944Y
136945N
136948R
136949E
136989D
136991N
136992C
136993P
136994R
136995E
137000S
137006A
137009J
137010Q
137018E
137019L
137020T
137023S
137054W
137201R
137204T
137206X
EG1002 113426D
121208B
122329T
126136J
130016W
130019K
130020D
130022N
130034B [/code]


only part of the data.

this piece of data means, for this module (subject, EG1001), these students(112960A,114424H, ... ) are taking it

i want to compare this 2 datasets to get the modulecode conflictive list.

Example: paper 1 : EG1832
Paper 2 : EG1833,EG1952,EG1903
Common Students: 5

Paper 10:Paper20 = 30 students (AdminNo)

Im actually doing a data loader for exam scheduling data.

Anyone give me a head start on how should i go about doing this in the easiest method, simplest to understand? Let me know of any possible ways i could do this.

i dont mind to have to transfer the data from excel to access database first, but preferrably by coding.

Thanks in advance!

Comments

Sign In or Register to comment.