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

RajKumar_DC (RajKumar Durai) October 17, 2022, 9:46am 7

Hi @Sami_Rajput ,

if you want to get value from DT2 against DT1 column value then you need to user below workflow.

Sequence.xaml (12.2 KB)

Thanks,
Rajkumar

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