Sections of data from excel to the Datatable

Help
1

Hi Folks,

I am having a excel sheet. where I am having huge data in it.
So how shall I get section of data from the excel. that is suppose I have some following rows.

stud_id name address
1 uuuu kdjkd oooppp
1 ddg dhhh
1
1

So now I have to get section of data for stud_id 1 i.e -
1 uuuu kdjkd oooppp
1 ddg dhhh
1
1
the above one is one section.

Below is one more section
2 jjjj kkkk
2 kkkss
2kkk

I am sharing a screen shot .
Based on column 1 we have to get sections of data to the
suppose Inv.D = 79792 then the rows corresponding to it should be taken to DT…

image
image957×325 12.3 KB

Regards,
Seema

2

Hi Seema,

Using the Filter rows u can remove or keep the based on the value .
Hope this will help you

Thanks,
Suresh J

3

Hi Suresh,

You mean to say the Filter activity?
1st I have to get the section of rows. that is section by section.
In the screenshot I have a - column- Inv D-
for 79792- I have got 2 rows of data -it should go to Datatable

for 79793, some 7 rows - again put it to Datatable.
It should happen dynamically.

I have taken this excel to DT. and now I have to get them in another data table and this DT2 should get filled dynamically.

Can you please help me out with this.

Thanks in Advance
Seema

4

Hello,

Have a look,
Excel_1.xlsx (8.5 KB)
EXCEL_2.xlsx (8.8 KB)
excel.xaml (9.1 KB)

5

Hi Seema,

GET the unique vaule of column 1 and create a array variable to it.
iterate the array using for each activity then use Filter Datatable activity, and get the data every unique data and write in sheet.

Hope this will help You.
Thanks,
Suresh J