How to get the data table data based on filter month wise

[sindhura506]

Hi
I have a Data table with Date column, using Date column i need to segregate the data monthly and quarterly wise.
I have tried with Filter Data table activity.But I have used fixed date condition.So, i’m getting only one month data only…i want to get all months datasets one by one
Any suggestions to how to do this one??

[Nithinkrishna]

Hey @sindhura506,

You can query the DataTable by means of the date field.

DT.AsEnumerable.Where(function(row) Date.Parse(row("date").ToString).Month = 2)

Something like above. Hope this helps.

Thanks

[sindhura506]

Actually we need to separate each month data by adding new 3 empty rows in between them.So, i need to identify each month data starting and ending position

[Nithinkrishna]

Hey @sindhura506,

Here is the core logic for you. You can re-modify or update as per your need.

DTMonthSep.zip (2.9 KB)

This will help you add empty row at the end of each month.

Thanks

[sindhura506]

Getting error message while using TestDT.Rows.IndexOf(TestDT.AsEnumerable.Last(function(row) CDate(row(“Date”).ToString).Month = item)) assign acitivity

[Nithinkrishna]

Kindly check in you imports(next to arguments panel) - whether do you have this System.Data.DataSetExtensions

Else please add

Thanks

[sindhura506]

can’t able to add System.Data.DataSetExtensions to imports

[Nithinkrishna]

AsEnumerable is not a member of 'System.Data.Datatable'

When trying to use the AsEnumerable() method on a data table, i receive a error stating that AsEnumerable is not a member of ‘System.Data.Datatable’. I’ve seen someone else with this problem and their solution was to use temporary data table activities in their project to load in the System.Data.DataSetExtension library. However this has not worked for me. Any help would be greatly appreciated. Thank you.

Could you please try this