Extracting information from an excel/ database based on the user input query

Hi Team,

I need your help. I am working on a problem. I have data set with 5 columns. One column has description (open text). other columns are demographics.
As a user i will input the keyword , then the bot has to search through the description column and send the report with all the rows matching that keyword along with other column.
Please let me know your views,

Thanks ,

Use For each row

  • If condition where row(“Description”).Equals(“Input keyword”)
    Then - Display the rest of the column values
1 Like

@srinivas_pradeep

For filtering your keyword check below for your reference
https://forum.uipath.com/t/tutorial-another-way-to-check-the-string-is-present-in-excel-or-not/245464/2

Once you filtered the datatable as above, Use For Each Row Activity to loop in to your filtered datatable. you can use variables to store the data and can use the same variable for your report

Hope this helps you

Thanks

1 Like

Thank you @ksrinu070184 . Really helpful. I am new to ui-path, is it possible to get the workflow please?

Cheers,

Thank you @hasib08

1 Like

Hi Team,

Merry christmas. Is it possible to get the workflow for performing this task?
Thanks
Sri