Add DataTable to another DataTable

Help Activities
, ,
1

Hi,

I want to add 1 DataTable to another DataTable. There is now common thing in those DataTables. They contain different data.
First one:
image
Second one:
image

Do you know how to combine those dataTables without loop?

Thank you in advance

2

You can use Merge datatable. Provide the source and destination tables according your needs and the you will get the desired output.

3

Merge action will add rows from second table to the end of first table. I want to keep data in original rows.

4

@mateusz.wojcik You have showed us the two datatable’s in above screenshot, so can you show us the output how you need in a screenshot?

5

This is the desired output

image
image958×261 13.9 KB

7

Hello @mateusz.wojcik

Please check the below video.

Thanks

8
9

Hi,

I watch the video and there is no answer to my question.

10

Hi,

Your solution has loop. I already have a loop I am now looking for simpler solution.