topic Getting unique records from two excel files in Talend Studio

Getting unique records from two excel files

sbhadra — Sat, 16 Nov 2024 02:31:43 GMT

Hi Team,

I have two excel sheets which has a column system id.

Excel 1 Details

Id|Name|Date|

1|Sumit|2019-10-11|

2|Amit|2019-08-07|

3|Ajit|2019-03-05|

Excel 2 Details

Id|Name|Date|

2|Sumit|2019-10-11|

4|Tom|2019-02-04|

5|Pat|2019-04-09|

Out of these columns I need only the Id as output and which should come as mentioned below

And the duplicate should be removed from the output. Please suggest on the same.

TRF — Mon, 04 May 2020 12:14:32 GMT

Merge both Excel flow using tUnite then eliminate duplicates using tUniqRow

sbhadra — Mon, 04 May 2020 13:37:42 GMT

Hi,

Now after getting the unique records, how I can iterate though the records and generate a separate file (in.xlsx) out of it.

TRF — Mon, 04 May 2020 13:39:47 GMT

Just replace tLogRow by tFileOutputExcel