Inserting data from one excel table to another v2

Help StudioX
, ,
1

I have data from one excel table (excel1) and want to insert it and add it to another table (excel2) where there is already data
how it can be realized?

how to remove merged rows in Excel in StudioX?
this combined line is at the end of the table and is separated from it by an empty line
excel2.xlsx (9.9 КБ)
excel1.xlsx (10.5 КБ)

2

Hi teslyak9437,
Try to follow the steps as below:

  1. Use a Read range activity to Extract the DataTable for each Excel file (Excel2 and Excel1). you can call them as follow: Excel1_DataTable and Excel2_DataTable.
  2. Use a Merge Data Table activity. In source you can type Excel1_DataTable and in Destination you can type Excel1_DataTable

NOTE: If you need to delete empty rows then you can use Remove duplicates activity

Cheers!

3

Can you send this process in StudioX please?

4

Help please with this excel