Answered

Merge/Concat Data tables in PAD

(0) Share

Report

Posted on by JuanPuelloUSGBC

Hi,

I have two datatable variables and I want to add all the values from DataTable2 to DataTable1. The tables have the same amount of columns. So, let's suppose this:

DataTable1: 2 Columns (Column1 - Column2) - 3 Rows

DataTable2: 2 Columns (Column1 - Column2) - 7 Rows

The expected result that I want is: 2 Columns (Column1 - Column2) - 10 Rows

I know I can achieve this with a for loop or even using Excel to paste the values and read all of them together. But those options don't work for me in my current use-case.

I was doing some research about using custom objects, JSON conversions, etc. but could not find anything useful. Maybe I can use some of the scripting actions available?

Thanks in advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

CU31080729-3 502 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
You can fallow the step as per given into the screenshot it may be work for you for adding one data table data to another table by using for loop

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Chetan Ninghot

Was this reply helpful? Yes No
JuanPuelloUSGBC 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the answer, but as I mentioned in the topic, I know that I can achieve this using a for loop or using Excel, but I am looking for a more efficient way to do this and also avoid changes in my data (Could happen if using Excel approach)

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,583 Super User 2026 Season 2 on at

Like
a
(3)

Report
Copy link

Link copied!
Then I would do it with a script as you were suggesting.

Before merge:
After merge:

Copy paste action to your PAD flow:

Scripting.RunDotNetScript Language: System.DotNetActionLanguageType.CSharp Script: $'''DT1.Merge(DT2); DT1 = DT1.DefaultView.ToTable();''' @'name:DT1': DataTable1 @'type:DT1': $'''Datatable''' @'direction:DT1': $'''InOut''' @'name:DT2': DataTable2 @'type:DT2': $'''Datatable''' @'direction:DT2': $'''In''' => DataTable1

Was this reply helpful? Yes No
JuanPuelloUSGBC 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! This seems to work just fine!

Was this reply helpful? Yes No
GenAi 80 on at

Like
a
(0)

Report
Copy link

Link copied!

How would you change this to merge multiple datatables. Lets assume there is datatable3,datatable4. Thank you

Was this reply helpful? Yes No
GenAi 80 on at

Like
a
(0)

Report
Copy link

Link copied!

I figured it out. Thank you

Was this reply helpful? Yes No