Extracting information from an excel file based on the user input keyword

Help
,
1

Hi Team,

Hope you are well.
Context: I have an excel file with 10 columns. Which include one of the column as open text with description.
Objective - Extract information from the open text column based on the user input keyword and extract the relevant information.
For eg.
if i have a dataset with 4 column

  1. column - city
  2. column - age
  3. column - location
  4. column - description - which contains the open text.

Requirement - User input the keyword “maintenance” then the bot has to search through the excel file say the "description " column and give user the rows where the “maintenance” word is appearing along with the other columns.

Please let me know how to achieve this,

thanks
Sri

2

Hi @srinivas_pradeep

Please check this workflow helps you,

inputTest - Copy.xlsx (8.7 KB) ExcelActivities.xaml (8.6 KB)

Thanks
Latika

3 Likes
3

Hi @Latika10011740,
Thank you so much. Appreciate it. I will have a look and get back to you.

cheers
Sri

5

Hi @Latika10011740,

Thank you. Its working nicely. However its giving me true or false. However i would like to get the output if “keyword” is present then give me the rows where the keywords are present along with other columns.
how can i go about it?
thanks