Hi all,

I'm new to Talend and is already looking to develop treatments that, in my opinion, seem to be complicated.

I have a multi-dimensional XLS file that I want to inject into a MySQL database. Here is my file structure

for the 1st sheet in the workbook that represents the month of January:

COL1 | COL2 | COL3 | COL4 | COL5 | COL6 | COL7 | COL8 | COLx ...
  day    prod.1            prod.1             prod.2             prod2
            2007              2008                2007               2008
    1       595                620                 340                 456
    2       459                569                 456                 567
    3       etc.

on the other side, I have a database table with the following strucure:

id_data
date_data
value_data
fk_id_prod

I wish I could do the following for each line of the file that corresponds to a day of the month:
- Can rework my field "date_data" from the day and year (I already know the month)
- Find the id of the product from its name (eg "prod.1"),
- Finally, add the data for each day of each year, for each product.

Do you have examples of specific treatment to get me?

Thank you in advance for any help you can give me.

Sincerely,