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:51pm 4

By the way, it looks like what you really need to do is just add the Supplier column and rename the Document Number column. Why bother moving data between datatables when you don’t need to?

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