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

image

Check out the Docs

Regards
Gokul

1 Like

Have a look on the XAML file @NS7799

RemoveParticularData.xaml (6.3 KB)

image

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

Thanks,
Sneha

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

Regards,
Gokul Jai

Thank you @Gokul_Jayakumar and @Gokul001 .

Will try and update you.

Hi @Gokul_Jayakumar ,

It’s working fine, Thanks a lot.

Regards,
Sneha.

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