Five Stars

Reapeat a rows value

Alright this might sound difficult, but i hope it is possible to do it in talend.

 

I have an excel which values are formated like this:

Excel Format.PNG

 

And what im trying to do is upload a table to mysql looking like this:

Output.PNG

 

Im not sure how to grab de letters from the left colum and move it down a row and repeat its value until the next letter shows up. Is this possible with talend? if so, can you guys help me with a quick demo or some pics?

 

Ty! <3

 

1 ACCEPTED SOLUTION

Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: Reapeat a rows value

Hi,

Here the tMap you need:Capture.PNG

and the result:

[statistics] connecting to socket on port 4023
[statistics] connected
.----+-----+-----+-----.
|      tLogRow_46      |
|=---+-----+-----+----=|
|Col1|Col2 |Col3 |Col4 |
|=---+-----+-----+----=|
|    |     |     |     |
|A   |Value|Value|Value|
|A   |Value|Value|Value|
|A   |Value|Value|Value|
|    |     |     |     |
|B   |Value|Value|Value|
|B   |Value|Value|Value|
|B   |Value|Value|Value|
|    |     |     |     |
|C   |Value|Value|Value|
|C   |Value|Value|Value|
|C   |Value|Value|Value|
|C   |Value|Value|Value|
|C   |Value|Value|Value|
|    |     |     |     |
|D   |Value|Value|Value|
'----+-----+-----+-----'

[statistics] disconnected

See this post for details.


TRF
3 REPLIES
Nine Stars

Re: Reapeat a rows value

you can try with tMap variables.

 

Regards,

Veeru Boppudi
Forteen Stars TRF
Forteen Stars

Re: Reapeat a rows value

Hi,

Here the tMap you need:Capture.PNG

and the result:

[statistics] connecting to socket on port 4023
[statistics] connected
.----+-----+-----+-----.
|      tLogRow_46      |
|=---+-----+-----+----=|
|Col1|Col2 |Col3 |Col4 |
|=---+-----+-----+----=|
|    |     |     |     |
|A   |Value|Value|Value|
|A   |Value|Value|Value|
|A   |Value|Value|Value|
|    |     |     |     |
|B   |Value|Value|Value|
|B   |Value|Value|Value|
|B   |Value|Value|Value|
|    |     |     |     |
|C   |Value|Value|Value|
|C   |Value|Value|Value|
|C   |Value|Value|Value|
|C   |Value|Value|Value|
|C   |Value|Value|Value|
|    |     |     |     |
|D   |Value|Value|Value|
'----+-----+-----+-----'

[statistics] disconnected

See this post for details.


TRF
Five Stars

Re: Reapeat a rows value

Ty! You helped me alot!