Hi I have got a problem with Execute Query activity. sometimes I got more than 1 values to search in SQL and then write in Excel. with 1 value seems it works for me but with more than 1 values, it doesnt work. my excel shows nothing in there. Im assuming the code needs to change in here? Eg in SQL…

[image] koolrc812: Execute @koolrc812 you will write this "select street_no, phone_no from data where phone_no in ('" + String.Join("','",Yourlist) + "')" cheers

Multiple values in SQL for Execute Query to excel

Help Activities

Anil_G (Anil Gorthi) December 12, 2022, 3:11pm 6

@koolrc812

You gave .txtfilename please remove dot and give comma

My mistake even i gave a dot extra

Cheers

Topic		Replies	Views
Execute multiple line query in UiPath Activities database , bug , completed	8	2917	July 22, 2022
Database query to excel file Studio studio , question , activities_panel	4	2273	November 16, 2021
Working on mysql workbench Activities database , activities , question	9	327	October 12, 2023
Using the SQL IN Operator Help activities , studio	3	1858	February 20, 2019
Can run multiple lines of query in uipath 'excute query activity'? Activities database , activities , question	5	2467	August 9, 2021

Multiple values in SQL for Execute Query to excel

Related topics