hi, I have 2 excel one is having complete records with header and second excel is having keywords with header(only one column is there). I have to segregate records with keyword search(keywords is in 2nd excel) from the 1st excel Description column and create 2 separate excels one will have the fi…

Read both the excels and store them in data tables. Then looping through the second data table, use filter data table activity and pass the value of second excel to filter and then get another data table. Let me know if it is confusing

Thank you @HareeshMR for replying. Yes, it is bit confusing and i am looking for a breakthrough or a solution other than filter data table. I hope i am able to express my query.

Yes you can do that using select of data table as well. I mean,datatable.select(“column name = value”).copytodatable which will give you another datatable and assign it directly to a datatable. So that you can write it or use it directly

Hi Hope this would help you [image] Compare Datatables one specific column with other specific Column and Get Matched and Not Matched Records` Academy Feedback Hello Community Use Below Code to Compare 2 Datatable Column and Get Matched and Not Matched Records Note- Bas…

Hi @indrajit.shah , [image] indrajit.shah: I hope i am able to express my query. I got it, I think this is exactly what you’re looking for, [image] Comparing two excel sheets and make it into new excel file Help hi @venkatmalla6 I think linQ will be the better opti…

@samir sir, i am not comparing two excel sheet, instead my use case is below - 1st excel with records but my prime focus is Description column 2nd excel with keywords(in the excel there is one column keywords, i have to use these column and filter which contains the keywords in the excel1 Descrip…

@Palaniyappan sir, actually in my case i am using 2nd excel sheet as and keywords to search the contains value in excel1. like in my 2nd excel the record is Wire so i will search the word wire in the 1st excel Description column if its contains the word then it will write in a different excel let s…

@HareeshMR sir, can you please explain this a bit. -Reading both the excel one by one using Read Range and storing in Recorddt1 and Keyworddt2 -Using For each Row item in Keyworddt2 Then how you suggesting??

Hi @indrajit.shah , Yeah it was just to give you an idea, there’s slight change in method, so as you have to search Keyword in every Description and find out whether it’s there or not, .Contains should be there. Use following code in assign to get description containing keywords. MatchedDescriptio…

Filter excel data by keyword

Help

indrajit.shah (iamvicky) December 28, 2019, 11:46am 11

@samir, thank you.

Can you help with this below error
Assign: The source contains no DataRows.

Topic		Replies	Views
Filter Data with contains Learning Hub datatable , excel , question	9	1373	March 13, 2020
[QUERY] FilterDataTable Activity Help	3	2131	December 21, 2023
Having a doubt to rectify Academic Alliance datatable , excel , academic_alliance , question	7	1290	March 10, 2022
Compare two data tables in different excel files Help datatable , excel , activities	21	20785	January 21, 2020
Filter data from data table 1 to data table 2 Studio uiautomation	7	1107	September 28, 2021

Filter excel data by keyword

Related topics