Get user input to generate data based on input

Help
, , ,
1

Hi,

I have a Description column in on of my excel sheet, and i want to ask user for the keyword to search and generate data based on the keyword input.

Keyword should be used as contains not as exact search. search should be dynamic.
Any idea how to achieve it??

@Palaniyappan, @ClaytonM, @Lahiru.Fernando need your suggestion guy’s

2

Yeah @indrajit.shah, you can use Filter DataTable activity for this. Also use contain operation mode to filter.

image

1 Like
3

Hi
yah we can use INPUT DIALOG BOX ACTIVITY and get the user input and store them with a string variable named str_input
–then with the datatable obtained ffrom READ RANGE activity and stored in a variable of type datatable named dt
–now use a FOR EACH ROW loop and pass the variable dt as input
–inside the loop use IF condition like this
row(“yourcolumname”).ToString.Contains(st_input)

Cheers @indrajit.shah

1 Like
4

if you have any sample to share???
and how do i ask for user input??
what i want to achieve is :
When bot will run it will ask user for keyword
then there is one for filter(for that also i am asking user to input in radio buttons)
then it will write the data in excel.

I am reading multiple excel sheet to get the desired output.

5

did these steps helped us on this

Cheers @indrajit.shah

6

I tried just now but not getting any output, the output is blank completely bank.

Main
Main637×4661 266 KB

7

Buddy its INPUT DIALOG BOX ACTIVITY where we can get the input from user
image

Cheers @indrajit.shah

8

NO NO its just a Message Box for testing purpose.
I have used Input Dialog for input
image

9

so have we used the IF condition within FOR EACH ROW like this next to the READ RANGE ACTIVITY

Cheers @indrajit.shah

10

Yes, Let me send you the Main file in personal message if its okay with you?

1 Like
11

sure
Cheers @indrajit.shah

1 Like
12

Can you please check.

13

This is the issue

image
image877×309 18.9 KB

in the assign activity mention like this
IDescription = row(“Description”).ToString
and in the IF condition mention like this
IDescription.ToString.Equals(VResponse.ToString) AND IPurchaseGroup.ToString.Equals(in_Keyword.ToString)

Cheers @indrajit.shah

14

still no luck :frowning:

15

Fine what is the source of ths datatable
finalMisVendorDT

Cheers @indrajit.shah

16

The 1st join i am using.

17

when using the value hard coded its working but when i am using variable name its not working.
image

18

Then we need to check whether that variable is passed with value or not
Kindly check the source of that variable
Cheers @indrajit.shah

19

variable is taking the right input, but how do i check where its searching with the same or not??

image
image879×199 7.69 KB

20

We can run in debug mode and check for it
Cheers @indrajit.shah

1 Like