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

loveleet_Saini (loveleet Saini) October 17, 2022, 7:24am 5

Hi @Sami_Rajput

Then You can First use Filter Datatable then you can Use Merge Datatable.

Regards
Loveleet Saini

1 Like

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