Filtering the Excel based on Column value

[vinjam_likitha]

Hi Team,

I want to filter Excel file where Action Column is Empty.

Input file will look like this:

Output file after filtering should be:

Thanks
Likitha

[supermanPunch (Arpan)]

Hi @vinjam_likitha ,

Have you tried using Filter Datatable Activity ?

[vinjam_likitha]

yes tried

By remove Action isnot empty

move to other datatable this i have added in filters

[supermanPunch (Arpan)]

@vinjam_likitha

move to other datatable this i have added in filters

@vinjam_likitha ,

What was the Output received after Filtering ?

[vinjam_likitha]

While filtering its faulting any other logic i can add for it

[supermanPunch (Arpan)]

@vinjam_likitha ,

Could you explain what is happening in a bit more detail ?

[loveleet_Saini]

Hi @vinjam_likitha

In FilterData table you must use Keep Column=“Action” & Value=“”.
Try using this.

regards
Loveleet Saini

[Bastian_Zamorano]

@vinjam_likitha Use filter datatable activity and give the filter rule that the column “Action” Is Empty, and click on Keep Rows

[Gokul001 (Gokul Balaji)]

Hi @vinjam_likitha

Have you tried with Filter Data Table activity? With the condition IsEmpty

Regards
gokul

[vinjam_likitha]

Hi

i used this its working for me

if i want from input Excel file “Final SR Status” is Open we need to filter and that row and second Scenarion if Action column is Empty

is this correct?

I am attaching input file

The output file i want is

The above filter works

Thanks
Likitha