topic Re: How to compare rows between two tables in Talend Studio

How to compare rows between two tables

Anonymous — Sat, 16 Nov 2024 08:11:42 GMT

Hello, so I have two table with the same columns, but no primary key.

Table 1

Name |

Tom |

Albert |

Tom |

Hawk |

Albert |

Harry |

Table 2

Name |

Tania |

Albert |

Tom |

Peter |

Essentially, I want to have 2 different outputs.
First output will be a table with names in Table 1 that can be found in Table 2

Output 1

Name |

Tom |

Albert |

Tom |

Albert |

Second output will be a table with names in Table 1 that cannot be found in Table 2

Output 2

Name |

Hawk |

Harry |

I have tried using tMap but I have no idea how I could go around doing it.

Re: How to compare rows between two tables

TRF — Tue, 29 May 2018 16:00:59 GMT

You just need 2 subjobs.

1rst one use Table1 as main row and Table2 as lookup with a tMap and inner join - rejeected rows will go to outpu1.

2nd one is just the reverse to the previous one.

The general design should be like this:

Here is what the tMap should look like (be carefull of red circled options):

The other tMap must be the same as this one.