Merge multiple extracted data table

Help
,
1

I have extracted 6-7 tables from the web and these tables are correlated.
After I write into excel, it will write into a new row after each table even though it combined on the same column.

  1. 6-7 tables and each tables have different number of rows and columns which is fixed from site
  2. All tables doesn’t have primary key
  3. Main objective is to combined all the table without creating a new row.

For example,

Table A (extracted datatable from web)
A|A|A
A|A|A

Table B (extracted datatable from web)
B|B
B|B
B|B

Table C (extracted datatable from web)
C|C
C|C

End result I get in excel
A|A|A
A|A|A
-------> B|B
-------> B|B
-------> B|B
-------------> C|C
-------------> C|C

End result I wanted
A|A|A|B|B|C|C
A|A|A|B|B|C|C
-------> B|B

Sort of how to join multiple extracted datable together as these tables are belong to 1 identity

2

@jackyWHJ
Table A to dt1

For each column in Table B
Add data column to dt1
Then add row values

Do this for all Tables you have…

Let me know the results…

3

I get what u mean the result will be:
A|A|A|B|B|C|C
A|A|A|B|B|C|C
------->|B|B
Is the same as I define different variables for each extracted datatable and write the column using write range

Sorry there’s an additional information I didn’t add in
For example,

A|A|A|B|B|C|C (guy A)
A|A|A|B|B|C|C
------->|B|B

(Empty row)

A|A|A|B|B|C|C (guy B)
------->|B|B

These three datatables that are merged belongs to each individual. By using that method is sort of merging everyones data together which can’t tell which range of data belong to whose.

So for each guy information are taken from 6-7 tables which consist of different rows and columns

How do I make it such that each guy’s data are properly written to excel

4

Is there any activity that can break line between excel after a single loop?

5

@jackyWHJ

can you provide some sample data and result you want?

6

uipathforum.xlsx (9.1 KB)

MOCKUP DATA
Highlighted with same color are from the same extract datatable
So in this example there are 3 different data table.
i have stated the expected outcome in the excel file.

7

@jackyWHJ

please check following excel, is this correct ?
uipathforum.xlsx (11.9 KB)

8

yes it is correct.
you split tables by different excel sheets.
What if each tables rows are varies? uipathforum.xlsx (9.4 KB)

@rahatadi

9

anyone? help plz