Filtering the Excel based on Column value

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

Hi @vinjam_likitha ,

Have you tried using Filter Datatable Activity ?

yes tried

By remove Action isnot empty

move to other datatable this i have added in filters

@vinjam_likitha ,

What was the Output received after Filtering ?

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

@vinjam_likitha ,

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

Hi @vinjam_likitha

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

regards
Loveleet Saini

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

Hi @vinjam_likitha

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

image

Regards
gokul

Hi

i used this its working for me

image

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?
image

I am attaching input file

The output file i want is

The above filter works

Thanks
Likitha

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.