I want to know how to pass excel output into the SQL queries for find matched values

Help Task Mining
,
1

here my query
select * from datatable where column_name in(acc_no,’ ‘,’ ')
here acc_no is dynamic from excel column

2

@Veera_Raj, Excel output you mean a DataTable/Row?

3

yes, i have to take that acc_no from acc_no column in excel and find mathced values from the sql database the column name is acc_number

4

You can try that by looping through your Excel Datatable.

Use CurrentRow(0).Item(“acc_number”).ToString.Trim. Assign a variable to that expression and pass that to your SQL Query.

P.S. CurrentRow is the Iterable for your DataTable.

5

@ManiPrajwal_K but i dont know how to pass that assign inside SQL query. can you tell me please ?

6

Here you go:

image
image831×317 14 KB

Create an In Argument and pass the assign activity variable in the Parameters.

P.S. Use @ in front of your argument in the SQL Query.

7

Hi

Welcome to UiPath forum

Check this thread for more details on how handle dynamic values in sql with a variable

Cheers @Veera_Raj

1 Like
8

thank you so much @ManiPrajwal_K i am going to try that

9

thank you so much @ManiPrajwal_K i am going to try that

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.