Key word search

Help
,
1

Hi Team,
I am new to UiPath. i need your help. 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.

For e.g. The columns are,

image

If a user search for key word “Beautiful” then it should return

image
Please let me know your views,

Thanks ,

1 Like
2

Hello @srinivas_pradeep,

you can try this

(From row in outDt.AsEnumerable() where row(“Text”).ToString.Contains(“beautiful”) Select row(“Age”)).ToList
you can select rows change column name from “Age” to “Gender”

Cheers
@srinivas_pradeep

1 Like
3

Hi @Pradeep_Shiv,

Thank you so much for the help. Is it possible to get a workflow please? I am new to this uipath.

Cheers,
Srinivas

4

Hi @srinivas_pradeep ,

Below it has an activity called find. It will search word and it will return the cellinfo and rowindex , It may help.

Thank you
Balamurugan.S

1 Like
5

Hi @balupad14 ,

Thank you so much. Really helpful. one question does it returns all the other columns along with the key word column where the key word is present?

Cheers,
Srinivas

1 Like
6

Yes. It will return all the column info. Because the return type is an array.

Thank you
Balamurugan.S

1 Like
7

Great @balupad14 . So it will finally export the filtered results into a new excel file?

Thanks and Regards,
Srinivas

1 Like
8

Alternatively to the @Pradeep_Shiv proposal you could simply use “Filter Data Table” activity to filter data table (that you will get from excel using “Read Range” activity)

Cheers

2 Likes
9

Thank you @J0ska. sorry i didnt get you. As i am completely new to this couldnt visualize.

10

Step 1/ Use “Read Range” activity to read your excel table into DataTable (e.g. dt1)
Step 2/ Use “Filter Data Table” activity to filter the dt1 based on provided keyword (e.g. “beautiful”)

Result will be a filtered DataTable dt2.

Screenshot of “Filter Data Table” wizard:
image

In case of fixed value “beautiful” you could use a string variable indeed.

Cheers

1 Like
11

Thank you @J0ska