Filter data excel with condition

[anh.nguyen]

Hi all,

I have 1file excel

1. I want filter remove column C condition “Cash” because 1 customer (A) have white line & yellow line as picture. So have to delete both (some customer code col A)
2. How i sum compare 2column (I + M file1) = (I + M file2)
   I new user can;t post link file. Thank you

[carmen]

Hi @anh.nguyen Welcome to the forum.

I would suggest start reading here …

Excel basics - click here to learn how to use Excel with UiPath

UiPath software allows you to perform several operation on your Excel files. If you want to learn about it in detail, please see our documentation here: Or go through the lessons in our Foundation course on the Academy. Here, I will mention a few quick facts that should get you going right away: There are two sets of activities: Excel Application Scope activities See this example to see how it works: ExcelApplicationScope.zip (1.9 KB) In short: it requires the MS Excel to be instal…

regards,

[Gokul001 (Gokul Balaji)]

Hi @anh.nguyen

Welcome to community

Have a look on the document for filtering.

Four Ways to Filter Data Tables in UiPath Studio | UiPath

To sum the column Try this below expression

(From d in dtData.AsEnumerable Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim)) Select v = CDbl(d(1).toString.Trim)).Sum(Function (x) x)

Here, d(1) → ColumnIndex, You can also use the column name with Double quotes

Regards
Gokul