Filter Excel File

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,

@CamiCat Check below statement once.

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

Thank you so so much @Manjuts90 :slight_smile:

1 Like

Here is something that you can try on your own for filtering data tables.
Pretty simple to use.

1 Like