I have an excel file and a column with with some numbers and at the end of the list I have #N/A, like this:
My question is, how do I configure the robot to filter that column to show only #N/A values?
The column name looks like this:
I tried the following methods:
Read Range > Output to Dt
Assign dt to
Dt.Select("[Avaya_ID_in_Group__Col_E_???] = ‘#N/A’").CopyToDataTable()
Dt.Select("[Avaya ID in Group] = ‘#N/A’).CopyToDataTable()
Dt.Select(“Avaya ID in Group (Col E)???” like ‘#N/A’ “).CopyToDataTable()
Dt.Select(”[Avaya_ID_in_Group] = ‘#N/A’).CopyToDataTable()
Dt.Select("[L3] = ‘#N/A’").CopyToDataTable()
L3 being the cell position on the sheet.
None of the assigned values above worked, most of the time I got the error [“Cannot find column]
Any ideas on how I should fix this please?