Merge two tables + iteration

[Anonymous]

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

[Anonymous]

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