Hi, I have two excel files - 1st excel file - One is having Column Name “Payment reference” 2n excl file - Column Name “Trans Item” My Query - -I have 2 DateTable DT1 and DT2 -From DT1 column name “Payment reference” have data(string) and in DT2 column named “Trans Item” which contains the st…

Check this workflow, @indrajit.shah Excel_DataUpdation.xaml (10.4 KB) and the output file Final_Transac_item.xlsx (7.5 KB)

Filter Data with contains

indrajit.shah (iamvicky) March 12, 2020, 6:25am 9

okay,

can you please look this one as well

Topic		Replies	Views
Filter Data Table of two city names Help datatable , activities , question	3	917	February 12, 2020
Filter excel data where duplicate data in each column to remain the same Help datatable , excel , studio , question	5	1090	November 8, 2020
Filter data from data table 1 to data table 2 Studio uiautomation	7	931	September 28, 2021
Filtering the datatable1 Activities excel , activities , question	11	833	August 27, 2021
Excel Activity - How to Filter the duplicate rows and add in a variable or save it in another datatable Studio	15	1205	July 9, 2020