Filter data from Excel

Help
, ,
1

I want to filter the data which I am looking only for the column State=CA and Entity= Raise. The below syntax I am using for filtering Can any one help me where I am getting wrong?

DtSave.Select(“STATE=CA” And “ENTITY=RAISE”)

2

You missed the single quotes in the select statement. Also column names and value needs to be case sensitive I believe. Here is the corrected expression.
DtSave.Select("State='CA' AND Entity='Raise'”)

Also you can try using the Filter Datatable activity if you find it easier to use.
https://docs.uipath.com/activities/lang-en/docs/filter-data-table

1 Like
3

@kaderms It was showing an error with your syntax I used "Option Strict on Disallows Implicit conversation from ‘String’ to ‘Integer’

4

Can you post a screenshot of the activity where you use select?
And also your output console that shows the error?

5

Hey thanks. I got this resolved

1 Like
6

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