Hello, 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: [test2] 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: [test] I tried the following methods: Read R…

Use Filter Table Activity. [image] Filter Table UiPath.Excel.Activities.ExcelFilterTable Filters a table from a spreadsheet based on existing values from a column. Can only be used in the Excel Application Scope or Use Excel File activities. Properties Input TableName - The name of th…

See this similar thread: [image] Filtering Column in Excel Academy Feedback Hi All, I need to filter column in excel where I want to filter column “courseNumber” which starts with 1013 and save it into another CSV…here is the screenshot of Excel…Quick suggestion and repl…

Nadim, I tried that but I get error [“Cannot find column]

Vivek, The file i’m working with is read-only and a table name is not defined for that data. I cannot create a table

Hey Alex, you need to Assign Column name Aditya

Dt.Select(“[Avaya ID in Group (Col E)???] like ‘#N/A’ “).CopyToDataTable()

Please try this. [image] Dt.select using column index instead of column name Help Hi, I am aware of the following method: dt.Select(“[Column Name] =”+“'”+blah+“'” ).CopyToDataTable but I have a dynamic column name so using column index will be a better approach. I got…

Nadim, I got the error: the expression contains invalid date contact “#N/A”

Hi @AlexMt , follow the thread below, it’ll help you. [image] Filter excel table to remove particular rows Help Okay smile for that take Filter Table activity Excel Application Scope and set the workbook path. Set all the parameters like sheetName, ColumnName and table …

How to filter a column in Excel

Help

nadim.warsi (Nadim Warsi) October 17, 2018, 1:11pm 3

See this similar thread:

Topic		Replies	Views
Filtrar #N/A de una columna Help excel	5	3964	December 3, 2019
#N/A filtrar Help excel , activities , question	3	1237	December 18, 2019
Excel filtering #N/A Activities excel	5	597	March 4, 2024
Apply filter in existing excel column, we have to apply filter without #N/A and empty cells Studio excel , studio	4	289	February 29, 2024
How to filter excel data table which contains #N/A values Studio studio , question , activities_panel	13	18321	May 26, 2021

How to filter a column in Excel

Related topics