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.
Thank you, this is simple one, i was trying much complicated one.
this solution let me with one question -
Is it filtering just like we do in excel?? like searching the string in the trans sheet trans item column? and is there any question it will return with duplicate records??