How do I filter out stuff in Excel?

Hi,

My problem is: I’m download an excel file with a column that I need to filter and save somewhere. I need to filter the data by predefined words however I know what words should NOT show.

So for example:

1

How can I set the automation that it shows for example: everything BESIDE E, F and G?

2

Please help:)

Hi @marcin.chowaniec

What about the following

(From d In yourDT.AsEnumerable()
Where Not d(“yourColumnName”).ToString().Trim().ToUpper.Equals(“E”) Or Not d(“yourColumnName”).ToString().Trim().ToUpper.Equals(“F”) Or Not d(“yourColumnName”).ToString().Trim().ToUpper.Equals(“G”) Select r = d).CopyToDataTable()

Regards

Hi, I’m a total begginer, how do I use it? where should I copy it?

Hi @marcin.chowaniec, you can create a variable of type ‘DataTable’ and use ‘Assign’/ ‘Set Variable Value’ activity.

image

Edit:
Alternate way…

Below are the filters for activity ‘Filter Data Table’

Please update the excel, sheet and variables according to you.

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