Excel: Need to Filter The rows

Help Studio
, ,
1

HI Team,

I have a DT and need to filter the DT and by value of rows.
DT is look like below.

Template Name Name First Name Last Name City
Test Yes Yes No Yes

If Test value was Yes we have to Keep that columns and columns names I need.

How to do? Can any one give the solution please.

Thanks,
Chethan P

2

Hi @copy_writes

Can you try below Query

filteredColumns  = String.Join(", ", DT.Columns.Cast(Of System.Data.DataColumn)().
                                            Where(Function(col) DT.AsEnumerable().
                                            Any(Function(row) row("Template Name").ToString() = "Test" AndAlso row(col.ColumnName).ToString() = "Yes")).
                                            Select(Function(col) col.ColumnName))

This image shows an automation workflow sequence in which an Excel workbook's specific sheet is read, filtered columns are concatenated into a string variable, and then displayed in a message box. (Captioned by AI)
This image shows an automation workflow sequence in which an Excel workbook's specific sheet is read, filtered columns are concatenated into a string variable, and then displayed in a message box. (Captioned by AI)914×606 22.3 KB

Regards,

3

What is variable type?

4

@copy_writes

String

Regards,

5

Is that Possible to Keep it in the Array format

6

Yes, How about the following?

The image is a UiPath sequence workflow that reads the "Sheet1" sheet from an "Excel1.xlsx" workbook and iterates over each column to write the column names to the output. (Captioned by AI)
The image is a UiPath sequence workflow that reads the "Sheet1" sheet from an "Excel1.xlsx" workbook and iterates over each column to write the column names to the output. (Captioned by AI)818×612 24.8 KB

DT.Columns.Cast(Of System.Data.DataColumn)().
                           Where(Function(col) DT.AsEnumerable().
                           Any(Function(row) row("Template Name").ToString() = "Test" AndAlso row(col.ColumnName).ToString() = "Yes")).
                           Select(Function(col) col.ColumnName).ToArray()

Output:

The image shows an output log from a process execution with specific fields highlighted, including "Name," "First Name," and "City." (Captioned by AI)

Regards,

7

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