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

Help Activities
,
1

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

2

Hi @NS7799

You can try with Filter Data table activity

image

Check out the Docs

Regards
Gokul

1 Like
3

Have a look on the XAML file @NS7799

RemoveParticularData.xaml (6.3 KB)

image

4

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

5

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

If yes, You can try with above XAML file

6

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

7

Thank you @Gokul_Jayakumar and @Gokul001 .

Will try and update you.

8

Hi @Gokul_Jayakumar ,

It’s working fine, Thanks a lot.

Regards,
Sneha.

9

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