topic Re: Insert multiple row from multiple column into one column in Talend Studio

Insert multiple row from multiple column into one column

Anonymous — Wed, 22 May 2019 11:11:45 GMT

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 ?!

Re: Insert multiple row from multiple column into one column

Anonymous — Wed, 22 May 2019 11:57:37 GMT

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

Re: Insert multiple row from multiple column into one column

Anonymous — Wed, 22 May 2019 12:13:50 GMT

Hello Youness,

Here's some hints :

Your job could be designed like this :

With this king of mapping inside th tMap :

Re: Insert multiple row from multiple column into one column

Anonymous — Wed, 22 May 2019 12:32:53 GMT

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

Re: Insert multiple row from multiple column into one column

Anonymous — Wed, 22 May 2019 14:09:28 GMT

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

Re: Insert multiple row from multiple column into one column

Anonymous — Wed, 22 May 2019 14:24:22 GMT

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

Re: Insert multiple row from multiple column into one column

Anonymous — Wed, 22 May 2019 17:26:11 GMT

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 ...

Re: Insert multiple row from multiple column into one column

Anonymous — Wed, 22 May 2019 17:30:51 GMT

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