Reapeat a rows value

[Anonymous]

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:

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

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! ❤️

[vboppudi]

you can try with tMap variables.

Regards,

[TRF · Accepted solution]

Hi,

Here the tMap you need:

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.

[Anonymous]

Ty! You helped me alot!