topic Re: Reapeat a rows value in Talend Studio

Reapeat a rows value

Anonymous — Thu, 26 Apr 2018 15:32:41 GMT

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

Re: Reapeat a rows value

vboppudi — Thu, 26 Apr 2018 15:37:50 GMT

you can try with tMap variables.

Regards,

Re: Reapeat a rows value

TRF — Thu, 26 Apr 2018 15:52:18 GMT

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.

Re: Reapeat a rows value

Anonymous — Thu, 26 Apr 2018 16:49:08 GMT

Ty! You helped me alot!