Big File Excel to MySql

[Anonymous]

Hi friends, i'm new in talend Data migration and i want to do like the picture, how can do it?? please i need help

[TRF · Accepted solution]

Hi,

Based on your sample data, here is a job which reply to your question:

tFixedFlowInput is just there for the example. It contains the same data as you have in your Excel file.

tSplitRow splits rows as expected:

tSortRow order output rows as expected:

And finally, tLogRow shows the result:

Starting job test at 09:06 16/10/2017.

[statistics] connecting to socket on port 3913
[statistics] connected
.--------+--------+--------+-----+--------+------.
|                   tLogRow_3                    |
|=-------+--------+--------+-----+--------+-----=|
|Title1  |Title2  |Title3  |Sales|Column  |Statut|
|=-------+--------+--------+-----+--------+-----=|
|Value 1 |Value 2 |Value 3 |0    |Value 13|PI    |
|Value 4 |Value 5 |Value 6 |1    |Value 14|PI    |
|Value 7 |Value 8 |Value 9 |1    |Value 15|PI    |
|Value 10|Value 11|Value 12|0    |Value 16|PI    |
|Value 1 |Value 2 |Value 3 |1    |Value 13|OF    |
|Value 4 |Value 5 |Value 6 |1    |Value 14|OF    |
|Value 7 |Value 8 |Value 9 |2    |Value 15|OF    |
|Value 10|Value 11|Value 12|2    |Value 16|OF    |
'--------+--------+--------+-----+--------+------'

[statistics] disconnected
Job test ended at 09:06 16/10/2017. [exit code=0]

Hope this helps.

[Anonymous]

Thanks you so much it's Work for me