Issue in filter data table

Help Studio
, ,
1

I need to extract data from a web application and export it to a data table. There are 4 columns and the number of rows will vary. after extracting it to data column i need to further filter the 4th column . the actual scenario is that the web application is a service desk application where i am extracting tickets based on 3 filters. and then i need to filter the 3rd column again and then i will get the exact number of tickets on which i need to work. Can anyone help me with this one?

2

@Ankita121
give a first try on the filter datatable activity
https://docs.uipath.com/activities/docs/filter-data-table

for more specific questions some more details on the data and the filter criteria would be helpfully for adressing the task more individually

3

I have already used this filter data table activity but i am facing an error that says that the value for argument Column Name is not set or invalid . I am directly giving the name of the column that i have used in the build data table activity . what to do now? @ppr

1 Like
4

@Ankita121
often a blank after the Value in the excel causes that a column name is not recognized.

  • check for this in Excel and do correction
  • use columnindex instead of column name
5

but i am not using excel . i am extracting data from the web application using the http activity and then i am using build data table and ported the entire data in that through add data row activity. After that i am using filter data table activity to filter it further. I have also checked values in data table through message box. the values are correct there.@ ppr

6

@Ankita121
the fastest help for us would be following:

  • a screenshot of the debugview (expanded datatable ) of the datatable at the state before you would do the filtering
  • screenshot of the build datatable settings (editor view)

Thanks

7

i am getting this error in filter data table : the value for argumnt column name is not set or invalid.
do we need to create an argument for column name here ?@ppr

8

i am not using any excel here. i am directly transferring data to data table by using build data table activity and add data row activity .after that i am using filter data table activity .@ppr

9

@Ankita121 Is it possible for you to show the Screenshots of your workflow? Or of Filter Datatable Activity ?

10

its solved now . I have used .net function instead of using this activity @supermanPunch,@ppr

1 Like