Skip to main content
Question

How to delete row if row contain value ="xyz"

  • 3 January 2022
  • 2 replies
  • 84 views

Capture

@Pradeep Kintali​  Please can you explain in detail as i am new to AA. i have data in datatable


@Yallaling Bansode​  - we can achieve it couple of ways

 

Excel - open

Loop - All rows in worksheet, inside loop write below if condition

if variablea2]= 'xyz'

Excel - Delete row

 

you can do it another ways also like Excel as DB or read worksheet as a datatable and filter rows and write final output to another worksheet/workbook.

 

If this helps you please do Like & mark as "Best Answer" so it will be helpful for others as well. 

 

Best Regards,

Pradeep.

 


Reply