Copy only empty cells row

hi
i have an excel where four column presents mrp,price,discount,rating. i want to do if empty data presents in mrp,price, discount. then i want to copy the whole row and write this empty data contains row in excel how can i do this?

@arijit1213

Can you share a sample data file?

Thanks

yes…
tst.xlsx (8.3 KB)
here i want to copy the whole row of product id-ASD0025, ASD0027 and write it in an excel then remove this two from the main excel sheet…because ASD0025 contains blank in sale price, discount field and ASD0027 contains alphabate in mrp,sales_price and discount column.

@arijit1213
have some demo xaml filtering the rows with blanks in any column
GetRowsWithBlanksInAnyCol.xaml (7.7 KB)

Hi @arijit1213

You can use a linq here assuming your datatable name is dt

dt1=new datatable()

dt1=(from dr as datarow in dt where dr.item("mrp").tostring.equals("") or dr.item("price").tostring.equals("") or dr.item("discount").tostring.equals("") select dr).copytodatatable()

Hope this helps you.

Hi @arijit1213

Try with this method

link for your reference https://www.uipath.com/community/rpa-community-blog/four-ways-to-filter-data-table-in-uipath-studio#:~:text=DataTable.Select()%20method&text=With%20the%20DataTable.,data%20table%20using%20this%20expression.