hi, how to read from [img 1] with those contain email at the request?
then read the excel from [img 2] to compare with [img 1]
after that, how to extract the certain data from [img 2] then add it into [img 3] as result with “email”
__
Hi @terrylim11,
how to read from [img 1] [you could use the Read Range activity https://docs.uipath.com/activities/docs/excel-read-range] with those contain email at the request? [for this, you can use the Filter Data Table activity https://docs.uipath.com/activities/docs/filter-data-table]
then read the excel from [img 2] [you could use also the Read Range activity] to compare with [img 1] [the Lookup Datatable https://docs.uipath.com/activities/docs/lookup-data-table will help you here]
after that, how to extract the certain data from [img 2] [the Filter Data Table activity can help you here] then add it into [img 3] as result with “email” [you can use the Merge Datatable activity https://docs.uipath.com/activities/docs/merge-data-table]
Hope this helps
Best regards,
Marius
okay I understand the logic. but how to make it work? hahahaha
filterDatatable.zip (26.3 KB)