Merge two tables + iteration

Anonymous — Mon, 05 Aug 2019 11:47:02 GMT

Hi All,

I have two similar dataset say for example as follows

Schema

Name, Address, Source

First Dataset

Name, Address, Source

AAAAAA, Address1, FIRST_SOURCE

BBBBBB, Address2, FIRST_SOURCE

Second Dataset

Name, Address, Source

ABABABABA, Address1, SECOND_SOURCE

CDCDCDCDC, Address2, SECOND_SOURCE

Expected output as Below

Name, Address, Source

AAAAAA, Address1, FIRST_SOURCE

ABABABABA, Address1, SECOND_SOURCE

CDCDCDCDC, Address2, SECOND_SOURCE

BBBBBB, Address2, FIRST_SOURCE

ABABABABA, Address1, SECOND_SOURCE

CDCDCDCDC, Address2, SECOND_SOURCE

i.e Pick each row from dataset 1 and merge it with entire dataset from dataset 2.

in 2nd iteration pick 2 row from dataset 1 and merge it with entire dataset from dataset 2 as follows

Please let me know if you need more details

Re: Merge two tables + iteration

Anonymous — Mon, 19 Aug 2019 05:02:46 GMT

Hello,

Are you using talend data integration or data preparation solution? In DI solution, please have a look at tMap component, which is primarily used for mapping input fields to output fields and transforming the input data in the Expression Builder of the corresponding output column.

Best regards

Sabrina

topic Merge two tables + iteration in Talend Studio

Merge two tables + iteration

Re: Merge two tables + iteration