Getting unique records from two excel files

[sbhadra]

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

Id

1

2

3

4

5

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

[TRF · Accepted solution]

Merge both Excel flow using tUnite then eliminate duplicates using tUniqRow

[sbhadra]

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]

Just replace tLogRow by tFileOutputExcel