Filter two excel sheets data and merge the data of two sheets which matches condition

Hi,

I have one excel as follows,

image
I have another excel as follows,
image

If item name =name then out put shpould be as follows,
image
any help please?

Hi,

You can read both the data into a datatable and then use Join Datatable activity.

Thanks,
Prateek

@Sachin_Sunny
Read both sheets in separate Datatables.
Pass both datatables to Join data table activity. And select inner join for match data.
Select columns relatives to both data tables.
Give output datatable.