I have two data tables Dt1 and DT2 DT1 ID | Name | Section 1 | Sami | A DT2 Grade | GPA A+ | 3.4 The final output In DT3 should be like this ID | Name | Section | Grade 1 | Sami | A | A+

Remove the inner For Each Row and create an index variable for the outer For Each loop. Change the Assign to: CurrentRow("Grade") = dt2(index)("Grade").Tostring Note: This only works if both dt1 and dt2 has the same number of rows. [image]

How to add specific Columns from one data table to another

Help Studio

Sami_Rajput (SR) October 17, 2022, 12:55pm 11

@tushar.c2
if I have many rows in DT2 then it will print only the last row every time
How can I handle that scenario

Topic		Replies	Views
Copy one column values from one datatable to another datatable Studio studio , question , activities_panel	5	7177	November 22, 2021
Add column values from one datatable to another basis a condition Studio studio , question , activities_panel	17	3134	January 16, 2022
How can I merge two data tables? Help	4	26968	April 4, 2019
Question: How to merge two data tables Help activities	14	6618	April 24, 2020
Add columns with data to existing Datatable Help studio	9	2988	October 21, 2019

How to add specific Columns from one data table to another

Related topics