Get user input to generate data based on input

[indrajit.shah (iamvicky)]

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

[kuppu_samy]

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

[Palaniyappan (Forum Leader)]

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

[indrajit.shah (iamvicky)]

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.

[Palaniyappan (Forum Leader)]

did these steps helped us on this

@Palaniyappan

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

[indrajit.shah (iamvicky)]

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

[Palaniyappan (Forum Leader)]

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

Cheers @indrajit.shah

[indrajit.shah (iamvicky)]

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

[Palaniyappan (Forum Leader)]

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

@Palaniyappan

–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

[indrajit.shah (iamvicky)]

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

[Palaniyappan (Forum Leader)]

sure
Cheers @indrajit.shah

[indrajit.shah (iamvicky)]

Can you please check.

[Palaniyappan (Forum Leader)]

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

[indrajit.shah (iamvicky)]

still no luck

[Palaniyappan (Forum Leader)]

Fine what is the source of ths datatable
finalMisVendorDT

Cheers @indrajit.shah

[indrajit.shah (iamvicky)]

The 1st join i am using.

[indrajit.shah (iamvicky)]

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

[Palaniyappan (Forum Leader)]

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

[indrajit.shah (iamvicky)]

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

[Palaniyappan (Forum Leader)]

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