Hi
DT1 has coulmns id, name year
DT2 has columns id name year(same data as dt1) but with additional column gender.
How to join gender column to dt1 or separate new dt combining both
@KarthikBallary What operation do you want to Perform on both Datatables 
? Do you want to find the Matching records between both tables, Do you want to Combine both Datatables to One Datatable or other operation
if you looking to join these DT1 & DT2 tables for a data query - you can use the Join Data Tables
activity. For more info on joindatatable activitiy - you can refer - https://docs.uipath.com/activities/docs/join-data-tables
if you are looking to add extra column - just to make both to sync - use the ‘Add Data Column’ activity for DT1 table.
Is this correct
club that gender column to that dt1…for coresponding ids
In the sense
DT1 ID-1, 2,3
DT2 ID-1,2,3 Gender-M,F,M
what if the ids are reordered in DT2, how it must be handled?
@KarthikBallary Then I guess you need to perform a Inner Join Operation using Join Datatables Activity
Join table will merge other duplicate columns also. I think I have to use invoke mehthod
How to add data coulmn object
@KarthikBallary How many Columns Do you have on both the Datatables?
DT1=4
DT2=5
What I need to pass here?
@KarthikBallary Is it possible for you to provide the Excel Files, If the Columns are less, then we might be able to use Join using Linq Query where you can choose the Columns you need in the Output Datatable After Joining, Thus eliminating Duplicate Columns
Gender.xlsx (9.2 KB) YOB.xlsx (9.4 KB)
@KarthikBallary, Can you please post expected output as well?
@KarthikBallary Check this :
JoinDT.zip (19.5 KB)
working fine thank u so much
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
Anil_G
sharazkm32
Steven_ds_55
Karla_Cristina_Santos_Cam
snehamayi.senapati
k-yamashita
mateuszmacheta
Manisha_Ravindra
Vishal_Verma1