Get user input to generate data based on input

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

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

image

1 Like

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

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.

did these steps helped us on this

Cheers @indrajit.shah

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

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

Cheers @indrajit.shah

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

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

Cheers @indrajit.shah

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

1 Like

sure
Cheers @indrajit.shah

1 Like

Can you please check.

This is the issue


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

still no luck :frowning:

Fine what is the source of ths datatable
finalMisVendorDT

Cheers @indrajit.shah

The 1st join i am using.

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

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

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

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

1 Like