SQL Database outputs 2 table in 1 Query

Help
, ,
1

Hi All,

I am automating an SQL database connection. The query outputs 2 tables.
When I execute the query through UiPath, I am getting only the 1st table in OutputVariable(datatable).
How to get both the Tables separately. Please advise. Thank You!

Attached pic for reference
2%20table%20op

2

hi @Reshma

Can I take a look at the query and how are you assigning it in UiPath?

3

Hi,

I am not supposed to share the query. I am using Execute query , and passing the query as Text.

image
image1065×297 11.3 KB

5

This activity basically throws the output in a single Data-table!!!

So I will suggest that you will require to split it into two queries!!!

This can be viewed from the properties tab :slight_smile:

6

Thank You.:slight_smile:
But the Clients is not agreeing to edit the already working query.
Let see if someone from UiPath team suggests a different work around.

1 Like
7

Hi Reshma,

Got you solution? Actually i am also facing the same issue.

8

Hi

Anybody got this solution? I am also looking the same.

Regards
Anand

9

Same problem here!
A little help maybe from @loginerror?
Thanks in advance!

10

I believe this to be some sort of limitation of the Database activity package. I tagged this topic with pr-welcome tag for anyone who would be willing to look at the code of the activity package here:

https://github.com/UiPath/Community.Activities/tree/master/Activities/Database

We will also have a look at it internally, but I can’t offer any specific timeline.

1 Like
11

thanks a lot for the ultra-fast reply!

1 Like
12

Hi All,

Anyone get the solution of this query?

13

I am also facing the same issue. Did we get any solution for this?

14

Run the two SQL queries separately.

15

I know that can be done, since this topic was raised 2 years ago so I was expecting the solution by UiPath till now on it.