Retrieve a data from datatable

Help Studio
1

I have a data table with multiple rows. Need to retrieve the data by grouping based on Year and currency.

Input Data table
image

Expected output
image

Please suggest an idea to do this.

2

Hi @suresh_panneer_selva

Welcome to forum

Do u need data seperately in each file or in same ?

3

Thank you. I want the output data to be in different data table. So I can loop that data for further process. Or please suggest me any good idea. I have to take each line item to be processed

4

Each DataRow corresponds to one row in your database, and contains a collection of columns. You can set the datatable as a datasource to many elements. The simplest way to extract data from a DataTable when you have multiple data types (not just strings) is to use the Field extension method available in the System.

5

Hi for this

U can use filter Datatable activity and filter it Accordingly to the condition of year and rowno

6

could you please suggest any sample