Delete row studiox not working

[Mark_Rajkumar (Mar)]

Unable to delete, any alternative?

[Gokul001 (Gokul Balaji)]

HI @Mark_Rajkumar

Check out this thread

Delete Excel rows

Hi, There is simple technique in Studiox to achieve your requirement. Please follow the below steps. Use excel file to choose your excel. Inside Use excel activity. Use filter activity to select your column name in our case balance and assign basic filter like is equal to “0” Now use the delete rows activity and select the option Delete all visible rows. now it is have ability to delete all rows with zero in the balance column at single shot. Use filter activity to again but this t…

Regards
Gokul

[Mark_Rajkumar (Mar)]

Hi @Gokul001 i did the same but not working

[Gokul001 (Gokul Balaji)]

Can you try to give the specific range? @Mark_Rajkumar

[Mark_Rajkumar (Mar)]

Can u give example @Gokul001

[Gokul001 (Gokul Balaji)]

Hi @Mark_Rajkumar

Check out this image: Add the position to delete the row in the excel

[Mark_Rajkumar (Mar)]

Ok will do @Gokul001. Can u explain what is position 1-10?

[Gokul001 (Gokul Balaji)]

@Mark_Rajkumar

explain what is position 1-10?

It something like start with ist row in the excel upto 10th row

[Mark_Rajkumar (Mar)]

I wan to filter and delete a specific row, how to fill up the position than? @Gokul001

[Gokul001 (Gokul Balaji)]

Have you tried with filter data table activity ? @Mark_Rajkumar

Regards
Gokul

[Mark_Rajkumar (Mar)]

I was trying but not sure how to use it @Gokul001. Any examples to share?

[Gokul001 (Gokul Balaji)]

Can you share the sample excel with Filter condition @Mark_Rajkumar

[Mark_Rajkumar (Mar)]

@Gokul001

[Gokul001 (Gokul Balaji)]

Can you tell us the Filter condition on this excel file and the output as well @Mark_Rajkumar

[Mark_Rajkumar (Mar)]

It is Green removing value of 289

[Mark_Rajkumar (Mar)]

@Gokul001 here

[Gokul001 (Gokul Balaji)]

Hi @Mark_Rajkumar

Try like this in the filter activity

Regards
Gokul

[Mark_Rajkumar (Mar)]

I am getting error value for argument name is not set or is invalid @Gokul001

[Gokul001 (Gokul Balaji)]

HI @Mark_Rajkumar

1. Use Read Range activity Set the Range as “A8”

2. Use Filter Data Table activity

Regards
Gokul

[Mark_Rajkumar (Mar)]

Hi @Gokul001 jus to ensure this will delete the whole row right?