Delete rows in Excel based on column data

[Chendoran_M]

Hi, Guys.

I have an excel sheet with 5 columns where 2 columns has blank data in it. I want to delete the entire row corresponding to blank data column. How can this be implemented using UiPath?

DeleteRow_Input.xlsx (9.7 KB)

Thankyou.

[Gokul_Jayakumar (Gokul Jai)]

Hello @Chendoran_M
Use Filter data table with Remove option

For more Undestandings, Refer to this video

UiPath Tutorial || Day 38 : Filter DataTable activity

[RajKumar_DC (RajKumar Durai)]

Hi @Chendoran_M ,

What about this workflow

Input

Output

Workflow

Xaml
Sequence4.xaml (11.5 KB)

Thanks,
Rajkumar