How to join the data tables in complex field?

Help
, ,
#1

Installer(.exe or .msi):

License type(Free, Trial/License code):

Studio/Robot version:

Current behavior:

Screenshot:

I have a question about join data tables in some complex field. I want to join the “sheet1” and “sheet2” with the same column, but what I need, is that if someone have other rows, then I should append other rows behind the first one, the case shown below.
sheet1:
image
sheet2:
image
sheet3(the result)

image
image.png696×196 5.9 KB

I want to get the result as shown in sheet3, so how to do it?
Thanksdemo.xlsx (12.8 KB)

#2

@wujiu2333

You can use Join Datatable activity to do this.

#3

I have used the Join Data Tables , but what I get just like below:
image
The ohter rows is joined row by row, not what I need in sheet3

#4

@lakshman, I use the Join Datatable can’t get the result shown in sheet3, things just like below:
image

#5

Try using the “add data column” activity: https://docs.uipath.com/activities/docs/add-data-column

#6

Hi,

You can use read range activity like you can read the data from “B1:J1” as per relevance and similarly write the data into an excel using write range activity with the required range like “A1:H1”.

Just DM me if any help required.

Cheers,
Sarthak Gulati