Assign after filter

Help Activities
, ,
1

Hi Team,

I need to read a cell after filtering the Excel sheet,
i mean the first step the BOT will filter the sheet with the Client name then every Client has a Code so i want to get that code in a variable

2

@omar_ismail

Excel Application Scope
-Provide the file path to your Excel file.

Read Range
-Specify the sheet name and range you want to read into a DataTable.
-Store the result in a DataTable variable

Filter Data Table
-Input: dtExcelData
-Filter Condition: Use a condition to filter the rows based on the client name.
For example, if the client name is in column “ClientName” and you want to filter by the name “ClientABC”:
“ClientName = ‘ClientABC’”
-Output: dtFilteredData

For Each Row
-Input: dtFilteredData
-For each row in dtFilteredData, you can access the code for the client and store it in a variable.
-Use an Assign activity to store the code in a variable.

-Assign: clientCode = row(“Code”).ToString()

3

@omar_ismail

You can use lookup range activity directly insteqd of filter…

Or you can as well read the data into datatable and use lookup datatable activity to get the required code directly

Hope this helps

Cheers