Insert multiple row from multiple column into one column

[Anonymous]

At first i will represent my input data
I have an Excel sheet that contains one table with the next columns :
- Code that belong to a student
- and 12 column that contain the result of the student in each module in school
So i want to split this table into 2 table in mysql the first table contain student informations and the second contain module results
Any suggestions ?!

[Anonymous]

tFileInputExcel ---------> tMap ------------mysql_table1
                                               ------------mysql_table2

[Anonymous]

Hello Youness,

Here's some hints :

Your job could be designed like this :

With this king of mapping inside th tMap :

[Anonymous]

The probelm that i want each results to have its own id in the table and not to have multiple results in the table
Only one result for each module that refers to the student

[Anonymous]

can you post sample file and also two images showing what you are expecting to have in each of the table?

[Anonymous]

This a simple example of my exel file
Code of student module1 result 1 module 2 result 2 ...
12345 php 14.5 mysql 16.75 ...
12346 php 13 mysql 16 ....
...

And i want to have an output like this
The first table student
Code of student
12345
12346

The second table module
Code of student module result
12345 php 14,5
12345 mysql 16.75
12346 php 13
12346 mysql 16

So i find a problem to take all the first line and insert it at the same time in all the table

[Anonymous]

Do you mean, you don't know the number of columns in the sample file?

Code of student module1 result 1 module 2 result 2 ... module100 result100 ...

[Anonymous]

No i know how much column, there is 6 module and each module have a result
So 6*2 = 12 columns are for the results information
And the column code of student for student information