Not able to add "Add Row activity"

[naveen.dsn (Naveen Kumar)]

Hi all.,

I am Beginner , i was doing a activity on my own, extacting the data in CSV For one month in yearly data sheet i some how managed to filter the dates and data, but now im trying to build a data new data sheet with one month data.

i have used Build data activity.

but not able use ADD rows to it.

can someday suggest and help me regarding this.

[ronanpeter]

Make sure you initialise the datatable before trying to add datarows to it

Initialisation of datatable

Hello, I’m working with a datatable: dt1 doing some selection on it: dt2=dt1.select(…) copy the result on dt3 with copytodatatable. dt3=dt2.copytodatatable after that i’m doing a condition on (dt3.Count.count) but: VisualBasicValue<Boolean> : Object référence not set to an instance of an object

[naveen.dsn (Naveen Kumar)]

Yes, i have tried it but its not working.

1. I have used Read CSV file and stored in dtinput data.
   2.Then i tried to filter data bw the dates 1/1/2018 to 31/1/2018, which i couldnt do it.
   with the help of forum
   i used Assign activity
   dtInputData.AsEnumerable().Where(Function(row) CDate(row(“Date”).ToString()) >= datetime.ParseExact(“01/01/2018”,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture) And CDate(row(“Date”).ToString()) <= datetime.ParseExact(“31/01/2018”,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)).toArray()

Then i used For each activity

and used Get row activity

Used a write line… to display what i have selected.
till here its fine,It displayed in the Output.

but when i created Build Data table.
and tried to move the filtered data in the new data table by using ADD Rows( In ArrayRow i placed the output in which i have row data, im not able do that.
Its displaying Compiler error encountered processing expression{.row_date}.
leading"." or"!" can only appear inside the "with"statement.

Stuck with this. since im a new user cannot upload the XAML file to show what i have done.

confused.

pl help…

Thanks

[Lahiru.Fernando]

Hi @naveen.dsn

Welcome to the community!!
I have created sample workflow for you to test it out. I have taken a set of data from excel file and trying do the same thing you want to do. It works fine.

DateFilterAndInsertToDataTable.zip (8.4 KB)

Check it out… This has the excel file and the sample workflow file. I have also added comments in workflow activities for you to easily understand why I have done it. So it will be helpful for you!

If this works for you, please mark the answer as the solution so it could help others as well… Its a good question by the way!!

[naveen.dsn (Naveen Kumar)]

thank you very much sir … it worked…