How to join the three tables in uipath?

Help
,
1

Hi Team,

how to join three tables in uipath?Three tables has same colomn name called “Employee Name” and i want to return three tables data (not a single table data)How to do this? Can anyone can help me out here?

Thanks and Regards,

2 Likes
2

Do you have example of the tables?

if you want to merge the datatables from 3 into 1 - do they all have the same table structure- i.e. column names?

2 Likes
3

Hey @TimK

They have different table structures…
I can give you example of table structure what i have

Table1:`EmployeeName Lastupdated Rank

Table2 :EmployeeName DateandTime Credits

Table3:EmployeeName DateandTime CreditsintheDB

2 Likes
4

Hello @vvaidya ,@loginerror, @nadim.warsi ,

Any Help on this?

1 Like
5

Use Merge Datatable Activity -
Merge table 1 with table 2
Merge Table 2 with table 3

This puts all your data into a single datatable - If you have the same sets of data across the different tables, you will need to then merge the data.

Use something like this : concatenate-multiple-rows-into-single-row

6

Hi @Timk

I dont think merge datatable activity will suite in this case ,bcoz all three tables has different data and different column names

7

Hi @cheersrpa,

what is your desired output? (table format etc)

You can use Merge and it will Add the schema together of the different tables.

8

Hey @TimK

I got the output by using join datatables activity by first two datatables and then join the output datatable with the third datatable.

using assign activity to fetch the desired columns

New System.Data.DataView(TempOutputDT2).ToTable(False,{“colomn1”,“colomn2”})

1 Like
9

Hi,

In case if you need to compare datatable- https://codeautomation.net/2018/12/comparing-datatables/

10

I am new to uipath and trying to learn new things So can you attach your sample wf here.

11

Hi @TUSHAR_DIWASE

take a look in the below things. you can get more things from here.

Regards
Balamurugan.S

12

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