How to filter datatable without using filter datatable activity?

Help
1

how to filter datatable without using filter datatable activity? as i am using uipath version earlier than 2018.02 so there is no “filter datatable activity”

2

You have to use DataTable.Select(filtercondition)

1 Like
3

I am using the Select method e.g DT_Temp.Select("[Airline]= "+ varAirline).CopyToDatatable
still giving error “Column not found”

1 Like
4

‘varAirline’ is this a number or string?

5

Its string variable

6

Try this DT_Temp.Select(“Airline='” + varAirline + “'”)

7

Tried but its still giving same error : Assign : Cannot find column [’AF’].
Actually AF is value of my varAirline variable.

8

Got it. A small mistake in the select filter.

DT_Temp.Select(“Airline=” + “'” + VarAirline + “'”)

1 Like
9

hi karthik
its also not working
pls giv specific code
m also struggling with same kind of scenario

Thanks

10

Make sure your data table contains headers. Else Select method won’t work.

Consider,

Data table is dt
Column to filter is Column1
Value to filter is searchValue

Use the following expression,

dt.Select("Column1='SearchValue'")

11

did the same but all in vain bro
I also used filter datatable activity also bt that’s also not working
don’t know wat to do

DataTableAutomation2.xaml (11.7 KB)
strData1.xlsx (13.4 KB)

12

Okay. Let me check your attachments.

13

what is your filter condition?

14

Hi

I have shared the flow and excel as well
first m reading the data by read range then putting assign activity lik s=dt.select(“Region=”+“'”+East+“'”)
like that

then I want to write the data into another sheet
how sud I do that?
showing this error
thanks

15

Hi @niteshbutola5

Can you please tell what is exact filter condition that you are looking for. from the image i can see that East is not declared as a variable.

Please use below code and let us know it is working or not.

TableDT.Select(“[Region] = ‘East’”).CopyToDataTable

Regards,
Vijay.

16

Hi @niteshbutola5

I change the flow and attached the file. please change the Excel File path in excel scope activities in both places.

The condition what i am check for is DTs.Select(“Region = ‘East’ or Region = ‘West’”).CopyToDataTable and writing same back to the excel sheet2.

Please check and let me know if this solved your problem or not.

DataTableAutomation2.xaml (12.1 KB)
strData1.xlsx (12.4 KB)

Regards,
Vijay.

17

thanks Vijay.
it worked.but with “and” condition its giving some error and
not providing the excat output.

18

East is not declared as variable ===means ???
I didn’t get u bro.

actually my requirement is to filter the excel sheet based on column values.
lets say I want only item = pen and pencil.

thanks

19

m facing issues with filter data table activity as well
not able to filter data with that activity.
pls help me on this
don’t know the excat reason

Screenshot%20(6)
Screenshot%20(6)1920×1080 132 KB

except east and west m getting central as well in new sheet

20

Hi @niteshbutola5

see on same column you can’t put Multiple Conditions with And. Generally if you have to select multiple values from same column then you have to use OR condition. If you have to select multiple values from Multiple columns you can use AND condition.

Regards,
Vijay