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 string from DT1.
-I have to filter those records from DT2 and write in a different excel with complete data from DT2.
Attaching both the excel for example Ref.xlsx (8.5 KB) TransItem.xls (22 KB)