How to add two data tables into one one data table, merge column wise

Help Studio
, ,
1

samplefile.xlsx (9.0 KB)
sheet1 contains only one column sheet2 contains 10 columns,
final result which I want is

image
image837×171 4.71 KB

2

Hello.

You can try using Append Range.
See if it works.

Hug

3

sorry but data is in datatable form not a exce the file.

4

Try this https://docs.uipath.com/activities/docs/merge-data-table

5

no its not working, I want to merge column into one

6

in excel we would just using

  • write range - dt2 (sheet2) with an offset to Range B2

On datatables we would handle it as a side by side merge

7

@ashishmani Try attached workflow

Example.zip (12.4 KB)

code

Input

Input

Output

output
output785×63 3.23 KB

8

HI , thanks for the reply but data comes from build data table, we not use excel here , I paste the excel as an example only

9

@ashishmani Try the below one

Example.zip (3.6 KB)

code

10

image

11

@ashishmani Are you using add data column activity before invoke method. Also, make sure you define data table DT2. Please follow the steps that attached in the workflow

12

thanks for your support.

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.