Hi ,
I have two Datatables. One has two rows two columns and the other DT has 2 rows… can somebody pls explain to me if these can be merged? I tried and i see the 2nd DT’s rows getting appended after two rows. sharing picture here. appreciate your help in advance.
Note:
DT2 has one column - COMBINED COUNTRIES
nv08
(Nilay Varshney)
January 19, 2021, 2:29pm
2
How are u expecting the data to be merged?
moenk
(Thomas Meier)
January 19, 2021, 3:46pm
4
Is this what you are looking for?
Table 1 Table 2
A B C
1 2 3
i want to merge these two, and get a table 3
A B C
1 2 3
But i think this is not possible. i need a roundabout. any suggestions?
Hi @Abinayaab
U can use append range activity for this to append two tables together
Hope it helps you
Regards
Nived N
Happy Automation
Hi @Abinayaab ,
If you want to combines rows from two tables by using values common to each other, according to a Join rule, you should go with the Join Data Table activity https://docs.uipath.com/activities/docs/join-data-tables
Hope this is what you are lookin for
Best regards,
Marius
1996
(Neelima G)
January 20, 2021, 8:54am
8
Hi @Abinayaab ,
Check this below article:
Hey @kalyanDev ,
I also want to know the fastest way of solving this kind of use case
[image]
However, there is an error:
[image]
Thanks!