Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Merge both Excel flow using tUnite then eliminate duplicates using tUniqRow
Merge both Excel flow using tUnite then eliminate duplicates using tUniqRow
Hi,
Now after getting the unique records, how I can iterate though the records and generate a separate file (in.xlsx) out of it.