Wondering how to merge the data from below files to same index, as I receive these files at different intervals.
One common thing with in these files is the student ID which is primary Key
File A: (Student Grades)
StudentID|StudentName|StudentGrade
P0172069|StuLast1|A
P0172369|StuLast2|A+
P0172269|StuLast3|B
P0172169|StuLast4|C
File B: (Student Attendance)
StudentID|Student Attendance | Expected Attendance |
P0172069|45 |70
P0172369|55|70
P0172269|72|70
P0172169|65|70
File C: (Student Majors)
StudentID|Subject 1 | Subject 2
P0172069|Maths |Maths
P0172369|Science |Physics
P0172269|Biology|Anatomy
P0172169|Computers|Software Engineering
Expected Output:
{
StudentID: P0172069
StudentName: StuLast1
StudentGrade: A
Student Attendance : 45
Expected Attendance: 70
Subject 1 : Maths
Subject 2 : Maths
StudentID: P0172369
StudentName: StuLast2
StudentGrade: A+
Student Attendance : 55
Expected Attendance: 70
Subject 1 : Science
Subject 2 : Physics
......
}