Filter Excel File

Help
1

Hello friends, (@rkelchuri, @Rammohan91, @balupad14, @Florent_Salendres, @vvaidya, )

I need to filter the Excel file that I’m attaching.
I need to extract only the rows which have in the colum "TIPOLOGIA " set to “TRAFFICO” and the “ELEMINTI_ID_CONSISTENZA” equal to a number, not to “N/A”.
Can you please help me?
esempio report BT - Copy.xls (37 KB)
Thank you so much,
cami

2

@CamiCat Check below statement once.

DatatTableVariable.Select("[TIPOLOGIA]='TRAFFICO' and [ELEMINTI_ID_CONSISTENZA]<>'N/A'").CopyToDataTable
4 Likes
3

Thank you so so much @Manjuts90 :slight_smile:

1 Like
4

Here is something that you can try on your own for filtering data tables.
Pretty simple to use.
https://activities.uipath.com/docs/filter-data-table

1 Like