How to add new Data Row using DataRow Input

Hi
How to add a new row in a DataTable using “DataRow” input?
Please refer below screen shot. What should I put there in Expression Editor?

2 Likes

Hey @abskulkarni

For your understanding here is a sample.

Abs@sample.xaml (8.3 KB)

if you are using for each iteration with argument “System.Data.Datarow” then you can just used that iteration object inside loop in add data row “DataRow” property.

if it belong to different table then you have to use arrayrow otherwise importrow method to copy datarows :slight_smile:

Things depends on your case… not much aware. So just uploaded a sample what you asked for :slight_smile:

Regards…!!
AKsh

13 Likes

Got it man… Your answer is always bang on… :slight_smile:

How to add data row from a scrapped data (data table)?

If I have a Excel Worksheet with 2500 lines, and I want to create a new Worksheet based on criteria. How could i copy the entire row into a new worksheet?