Hi Team, Here i am having data table Dt_1 where i need to add this data row in different data table having different column names as shown below DT_1: [DT_1] DT_Final(Expected output) [DT_Final] Please suggest any solution using LINQ Regards, Sai Adarsh.

Hi @adarsh_kotagiri , What about below Input [image] Output [image] Workflow [image] Xaml Sequence.xaml (9.5 KB) Query (From row In dt1.AsEnumerable Let outrous = (row("Date").ToString+","+row("Document Number").ToString+",,"+row("Amount").ToString).ToString Select dt2.Clone.Rows.Add(outr…

How to add data row in different data table of different column using linq

Help Studio

postwick (Paul Ostwick) November 23, 2022, 5:50pm 3

Why do you want to use Linq? Add Data Row will work just fine.

1 Like

Topic		Replies	Views
I need to copy data from data table1 to data table2 which has different column names Activities activities , question , document_understanding	8	309	November 30, 2023
LINQ to Add Column from one DataTable to Another Studio	5	1118	January 10, 2024
Add column to another table Activities question , system	4	603	October 16, 2023
How to add column with its data to another data table Something Else activities	21	1910	November 7, 2023
How to type into Datatable Studio studio , question , activities_panel	5	571	April 7, 2023

How to add data row in different data table of different column using linq

Related topics