How to exclude cloumnB data which contains "SF" in a excel

Hi Team,

I have one excel which contains 9 columns.
Before doing any operations I want exclude the data which contains SF in a column B.

How to exclude the data which contains SF in a column B .

Please help me to slove the issue.

Please suggest.

Thanks in advance

Hi @NS7799

You can try with Filter Data table activity


Check out the Docs


1 Like

Have a look on the XAML file @NS7799

RemoveParticularData.xaml (6.3 KB)


Thank You @Gokul001 for quick response.

I don’t want to remove the columns.
Just need to exclude those columns which contains SF in a column B .
And then perform another validation.

Need to ignore those columns.

Please suggest @Gokul001


Need to Remove the SF value from the Column B correct?

If yes, You can try with above XAML file

Hello @NS7799
Kindly try this

  • Use If condtion activity with in for each loop
  • Use condition Not CurrentRow("Column B").ToString.Contains("SF") , in Then sequence, frame your flow need to run without SF, If SF value in Column B, it will goes to else and next loop starts.

Gokul Jai

Thank you @Gokul_Jayakumar and @Gokul001 .

Will try and update you.

Hi @Gokul_Jayakumar ,

It’s working fine, Thanks a lot.


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