topic Re: Data arrangement: multiple rows data in one row in Talend Studio

Data arrangement: multiple rows data in one row

vidya821 — Tue, 04 Jul 2017 08:45:47 GMT

Hi,

Here is my requirement

INPUT FILE FORMAT

CONTRACT_NO | NAME | DOB

1 | JOHN | 01/01/2016

1 | SMITH | 05/05/2016

2 | JASON | 06/06/2016

OUTPUT FILE FORMAT

CONTRACT_NO | NAME1 | DOB1 | NAME2| DOB2

1 | JOHN | 01/01/2016 | SMITH | 05/05/2016

2 | JASON | 06/06/2016 | |

Merge the data with same contract_no into one row

Please let me know which components can be used to achieve the desired output.

Thanks.

Re: Data arrangement: multiple rows data in one row

TRF — Tue, 04 Jul 2017 13:29:50 GMT

Here is what you expect.

tMap is used to autojoin the entry with itself (here represented by a tFixedFlowInput).

a tUniqRow is used on the main flow to get only the 1st rw for a given contract_no.

Here is the tMap :

On the left side:

- use join model = Left Outer Join in case of only 1 row for a contract_no

- filter on the name to avoid the rows to be join with themself

On the right side:

- in case of null value, replace by an empty string ("")

Hope this helps.

Re: Data arrangement: multiple rows data in one row

vidya821 — Wed, 05 Jul 2017 09:52:50 GMT

Hi,
Thanks for solution.
I want to link delimited file as input to tUniqRow
but getting a warning on the tInputDelimited as This component shud have input links

warning.png

Re: Data arrangement: multiple rows data in one row

vidya821 — Wed, 05 Jul 2017 09:58:31 GMT

Sorry i entered wrong component as input component..my mistake

Re: Data arrangement: multiple rows data in one row

Bluemoon — Wed, 05 Jul 2017 19:43:46 GMT

Hi ,

I want to add another approach of getting a solution for this problem

Re: Data arrangement: multiple rows data in one row

Anonymous — Thu, 06 Jul 2017 04:30:56 GMT

Hello,

Thanks for posting your another approach on forum.

Best regards

Sabrina