Why is my excel file not filtering and sorting?

Help
1

Hey everyone for some reason my excel file is not filtering and sorting.
|7.6|Filter column ‘sources/modules’ and select ‘IT Risk Mgmt’ and ‘Third Party’. |
|7.7|Go to column ‘sub status’ and deselect ASO Followup (Pending Closure)|
|7.8|Sort column ‘due date’ from oldest to latest.|

image

image

2

HI @seanp92

Looks like in the filter wizard, you are not specifying the column names properly. In the filter wizard, all the column names should be within the double quotations.

“Sources_Modules”
“SubStatusIndex”

For sorting, Provide the column which you want the data to be sorted. You can specifying the sort column under “Name” property of Sorting Column section. Make sure to enter the column name within double quotations…

Let know whether it helps…

3

column name is not set or is invalid. When I put quotes around Sources Moddules and Substatus index

4

Hi @seanp92

  1. Buddy instead of columnname to be mentioned directly why not you mention like
    dt.columns(your column index)

The reason is sometimes we might miss some characters or the wrong column name even. So try to mention it with column index

  1. And the column substatusindex might not have any records with sources_modules values like “IT Risk Mgmt” and “Third Party”. Kindly check once with that so that it might not have got filtered

3… Kindly check whether the input table has such columns
4. After that check once whether the data is getting filtered first, to check use outputdatatable with input the datatable with filtered data and output a text variable rom outputdatatable, Then use a writeline activity priniting in log from which we can check with data…then use sort buddy…this is done usually to check with data

Otherwise you are going good buddy…
this link could give you more details

https://activities.uipath.com/docs/filter-data-table

Hope this would help you

Cheers…

5

Is that working buddy @seanp92

Cheers…