Appending new column in existing excel from another excel

Help
1

how can i append new column in existing excel from another excel ?
Please help

2

When you say append, do you mean join? For you to add another column to another existing excel( or datatable, you need a common column (ie. PK) to merge(append, join) them.

Existing excel: ExcelA
Another excel: ExcelB

Read the ExcelA. output would be dt_A.
Read the ExcelB. output would be dt_B.
Merge/Join them with common column (Primary Key=PK), retain the only needed column
Write Range to Excel B with the update datatable.

1 Like
3

Screenshot%20(39)
Screenshot%20(39)1920×1080 123 KB

hey im getting this error
can you help me ?

4

Hi @Mayur_Pawar

Check the data type of zoom column

It should be unique

Thanks
Ashwin S

5

No i don’t want to perform join operation.
let say i have excel 1 and excel 2
every time i received new excel 1 but from that only i want only one column let say XYZ and in second excel i have to append only XYZ columns values only.

6

@Mayur_Pawar

In that case you can

  1. just read excel 1.
  2. get the excel 2 used range of that column(xyz).
  3. use write range and pass range dynamically from step 2.
7
  1. Read excel 1 and excel 2 store them in data tables
  2. Use Add data column activity for the first excel data table and pass the column you want from excel 2. then you can use that data table to write it back @Mayur_Pawar