Showing results for 
Search instead for 
Did you mean: 
Advocate III
Advocate III

Datatable Joins

I have two DataTable variables in PAD and need to join them. Is there a way to do this in PAD without using a SQL database?

Resolver II
Resolver II


The number of columns needs to be the same.

try it sample.


SET NewVar TO {[1, 2, 4], [6, 7, 8] }
SET NewVar2 TO {[8, 2, 4], [6, 7, 8], [5, 6, 7] }
LOOP LoopIndex FROM 0 TO NewVar2.RowsCount - 1 STEP 1
SET NewVar TO NewVar + NewVar2[LoopIndex]

スクリーンショット 2021-06-02 010133.jpg

Thanks for the reply @ZS440 , but it looks like your solution produces a UNION, but I'm looking for a JOIN (specifically LEFT JOIN).

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,607)