Append data

Help
, ,
1

I have tried to append rows of by cloumns, the original data looks like this
Datatable1
Name Date1 Cost1
A 2013-03-25 1,923,245.06
B 2015-06-04 4,104,660.00
C 2015-09-10 771,540.00
D 2013-07-19 1,917,441.27
E 2015-06-02 - 1,261,474.52
F 2015-07-27

Datatable2
Date2 Cost2

A 2017-10-16 392,073.48

B 2017-10-16 392,073.48

C 2016-10-14 476,390.88

D 2016-07-28 153,216.00
E 2015-09-29 47,151.00
F 47,151.00

and I want it to look like this,
Name Date Cost
A 2013-03-25 1,923,245.06
B 2015-06-04 4,104,660.00
C 2015-09-10 771,540.00
D 2013-07-19 1,917,441.27
E 2015-06-02 - 1,261,474.52
F 2015-07-27
A 2017-10-16 392,073.48

B 2017-10-16 392,073.48

C 2016-10-14 476,390.88

D 2016-07-28 153,216.00
E 2015-09-29 47,151.00
F 47,151.00
pls help me

2

Hi
welcome to UiPath community
so we dont have the columnname Name in datatable2, is it so

@Vivek_Kumar3

3

Hi sorry we have column name - Name2

4

then we can use MERGE DATATBLE ACTIVIY
for more details

Cheers @Vivek_Kumar3

5

Thanks for replying
but here is different different column name
how we can merge this type of data

1 Like
6

That’s a good question
Once after getting the second datatable
Change the column name with assign activity like this
Dt2.Columns(“yourcolumnname”).ColumnName = “same column name in Dt1”

Similarly for other columns as well with assign activity

cheers @Vivek_Kumar3

7

thanks u so much i am trying

1 Like
8

Sure
Kindly try this and let know for any queries or clarification
Cheers @Vivek_Kumar3

9

data table1 column name
Candidate_Name Current_Organization Current_Designation Location Email FunctionalArea Industry SKILL_SET

data table2 column name
Name Curr. Company name Curr. Company Designation Current Location Email ID Functional Area Industry Key Skills

data table3 column name
Name Current Employer Current Location Email Roles Industry

data table4 column name

Candidate Name Current Organisation Candidate Current Location Email Id

i want to append all data in datatable1 pls give me suggestion
thanks

10

Hi
did we try with JOIN DATATABLE activity with primary column taken for JOIN condition among the datatable
@Vivek_Kumar3

11

Sometimes is just better to do the easy way, just create a new datatable and one for each for each of your source datatables, the use add data row and add them all to the new datatable…

12

Thanks

13

But here is different types of column name
for different different type of data table

14

this is not working well
please suggest me
thanks

15

May I know how the result looks like
@Vivek_Kumar3

16

i dont want to create
new column
first first data table is master data table

i need to append condition wise
data table 1
column 1 - Candidate_Name
data table 2
column 1 - Name
data table 6
column 1-full_name
like this for all column
thanks