How to join 2 datatable with 1 column by their indexes

Help Activities
, , ,
1

Hey everyone,

I have 2 datatables with 1 column. First dt has the column named “item”, second datatables column is named “number”, I read them seperately from excel and I want to add the 2 datatables together. To example it

DT1:

item
15
3
2
1
5

DT2:
Number
7
8
9
4
6

These 2 tables always will have exact same number of rows. So i want to join them or merge them as

item ** Number
8 *******7
3 *******8
2 *******9
1 *******4
5 *******6

Any suggestions?

2

Hi @jntrk ,

Use join data table activity to join 2 tables

Refer below link for join two tables

Regards,
Arivu

3

the join table you sent wont work because my tables dont have anything in common. I just need to get them together as 1 datatable

4

Hi @jntrk,

Use join data table activity

Regards,
Arivu

5

Hi @jntrk

Write both the datatables to the Excel and read the excel again and store that to the datatable.

Read range excel 1 - dt1
Read range excel 2 - dt2

Write range dt1 - A1
Write range dt2 - B1

Read range new excel - dt3

Thanks

6

Yea this works absolutely :slight_smile: but i thought maybe there is a more efficient way.

7

I dont have a join condition.

8

we can do it with a side by side merge (Not merge activity)

find a first introduction on examples here:

1 Like