Skip to main content
Question

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


Capture

2 replies

  • Author
  • Navigator | Tier 3
  • 10 replies
  • January 3, 2022

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


Pradeep Kintali
Most Valuable Pathfinder
Forum|alt.badge.img+5
  • Most Valuable Pathfinder
  • 127 replies
  • January 3, 2022

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

 

Excel - open

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

if variable[2]= '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.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings