It us about arranging status of details in an escel sheet

Help Studio
, ,
1

Read given excel contains 4 columns. member name, age, amount and status
Read excel and group all the rows with status as completed
Group all rows with status as error
Create two sheets in the same excel as error and completed
write the above group of rows to corresponding tabs and save the excel

can u please give some hints to solve this

2 Likes
2

@Anjana_R

Read the excel using Read Range Workbook
Use Filter Datatable activity

image
image1130Ă—567 36.9 KB

Use Another Filter Datatable activity
“Status”=“Error”
Write range workbook for Completion
Write range workbook for error

3

Thank you sir for helping me .

4

@Anjana_R

If this helps you mark as solution to close the loop
Thanks

5

Hi @Anjana_R

Welcome to the community

Datatable.DataView.ToTable(false,“ColumnName1”,“ColumnName2”,ColumnName3,ColumnName4)

Use the above syntax in assign activitiy
Wil give you a fast result than filter datatable activity

Hope this helps you

6

yes sir, i will try this and update here soon

7

thank you ma’am for a new method. will try this

1 Like
8

Hi @Anjana_R

Could you be more specific in process, I just confused to understand your query.

If you elaborate your query then we will bring you the possible solutions.