Copy only empty cells row

[arijit1213 (Arijit Chowdhury)]

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?

[Srini84 (Srinivas)]

@arijit1213

Can you share a sample data file?

Thanks

[arijit1213 (Arijit Chowdhury)]

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.

[ppr (Peter)]

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

[Lakshay_Verma]

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.

[vijaybrijmohan14 (Vijay Brijmohan)]

Hi @arijit1213

Try with this method

link for your reference Four Ways to Filter Data Tables in UiPath Studio | UiPath.