Five Stars

Big File Excel to MySql

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

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars TRF
Twelve Stars

Re: Big File Excel to MySql

Hi,

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

Capture.PNG

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

Capture.PNG

tSplitRow splits rows as expected:

Capture.PNG

tSortRow order output rows as expected:

Capture.PNG

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.


TRF
2 REPLIES
Twelve Stars TRF
Twelve Stars

Re: Big File Excel to MySql

Hi,

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

Capture.PNG

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

Capture.PNG

tSplitRow splits rows as expected:

Capture.PNG

tSortRow order output rows as expected:

Capture.PNG

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.


TRF
Five Stars

Re: Big File Excel to MySql

Thanks you so much it's Work for me