How to multiple filter apply in excel using linq

Help Activities
, ,
1

Hi Team

I want to two filter and based on the result i should print new sheet of same excel .

Filter column2 “aaaa” , “bbbb” column4 if found “US” add sheet update the filtered data
Same filter column4 found CA add sheet “CA” and update the data.

Please help me anyone for this.

Please find the attachment for sample excel
Book1 (Recovered).xlsx (10.9 KB)

Regards,
Raja G

2

Hi @Raja.G

Try this

The image depicts a sequence workflow in an application, where data is read from an Excel workbook, assigned to two variables ( and ), and then written back to different sheets ("DTUS" and "DTCA") within the same workbook. (Captioned by AI)
The image depicts a sequence workflow in an application, where data is read from an Excel workbook, assigned to two variables ( and ), and then written back to different sheets ("DTUS" and "DTCA") within the same workbook. (Captioned by AI)818×759 46.4 KB

dtUS = DT.AsEnumerable().Where(Function(row) (row("Column2").ToString = "aaaa" OrElse row("Column2").ToString = "bbbb") AndAlso row("Column4").ToString = "US").CopyToDataTable()

dtCA = DT.AsEnumerable().Where(Function(row) (row("Column2").ToString = "aaaa" OrElse row("Column2").ToString = "bbbb") AndAlso row("Column4").ToString = "CA").CopyToDataTable()

Regards,

3

Hi @lrtetala ,

If filter there is no data found then linq not work right throw error, i dont want to throw error i want to skip so how to do that , please help me on this.

Regards,
Raja G

4

you can use if else activity and put the following condition:

DT.AsEnumerable().Where(Function(row) (row(“Column2”).ToString.Equals(“aaaa”) OrElse row(“Column2”).ToString.Equals(“bbbb”)) AndAlso row(“Column4”).ToString.Equals(“US”)).any()

and Assign dtUS = DT.AsEnumerable().Where(Function(row) (row(“Column2”).ToString.Equals(“aaaa”) OrElse row(“Column2”).ToString.Equals(“bbbb”)) AndAlso row(“Column4”).ToString.Equals(“US”)).CopyToDataTable

and do the same for other table (CA)

The image shows an UiPath workflow with an "If" condition and "Assign" activity, including the Expression Editor where the condition filters a DataTable for rows where Column2 equals "aaaa" or "bbbb" and Column4 is "US". (Captioned by AI)
The image shows an UiPath workflow with an "If" condition and "Assign" activity, including the Expression Editor where the condition filters a DataTable for rows where Column2 equals "aaaa" or "bbbb" and Column4 is "US". (Captioned by AI)1382×596 79.9 KB

1 Like
5

@Raja.G

Try this way

The image shows a sequence in UiPath for reading an Excel workbook, filtering data into two distinct DataTables, and conditionally writing them to separate sheets based on data presence. (Captioned by AI)
The image shows a sequence in UiPath for reading an Excel workbook, filtering data into two distinct DataTables, and conditionally writing them to separate sheets based on data presence. (Captioned by AI)818×1469 72.7 KB

dtUS = DT.AsEnumerable().Where(Function(row) (row("Column2").ToString = "aaaa" OrElse row("Column2").ToString = "bbbb") AndAlso row("Column4").ToString = "US")
dtCA = DT.AsEnumerable().Where(Function(row) (row("Column2").ToString = "aaaa" OrElse row("Column2").ToString = "bbbb") AndAlso row("Column4").ToString = "CA")

The image shows a variables panel in a software environment with three variables named "DT," "dtUS," and "dtCA," each with their types and scopes specified. (Captioned by AI)
The image shows a variables panel in a software environment with three variables named "DT," "dtUS," and "dtCA," each with their types and scopes specified. (Captioned by AI)1071×328 15.4 KB

Sequence20.xaml (13.3 KB)

Regards,

6

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