Unable to perform filter activity

Hi Friends,

Could any one help on below error, i tried to perform filter data activity for excel but unable to perform please have look below error and advise

image

My Excel column names
image

given column names for filter table activity
image

Thanks in advance

Hi,

First, can you check your Read Range Activity - Add Headers property is true?

Regards,

1 Like

hi @Yoichi

Thanks for your response

As per your request i have cross checked in the read range activity - Add header property is checked and it’s true…:slightly_frowning_face:

Hi,

Thank you for checking.

Can you try the following?

  1. Set breakpoint at the Filter DataTable Activity and run debug mode.
  2. Then program will stop at the activity, so you can check content of your datatable at Locals panel as the following image. Please check if it is same as what you expected.

Regards,

1 Like

hi @Yoichi

Really thanks for your help!
I tried to put break point for filter activity, could please advise how to check property value after break point placed Hence, am new to uipath please :slight_smile:

Hi,

Basic steps would be the following.

  1. Set breakpoint at the Filter DataTable Activity (click Breakpoint on DebugTab in Ribbon)
  2. Click Debug File in Ribbon
  3. Then program stop at the activity.
  4. You can see DT1 in Locals Panel. And you can also see details if you click magnifying glass icon.

Which step have you completed?

Regards,

Hi @Dhanraj_Guduru,

Try this xaml,it should work.
ExcelFilterActivity.xaml (7.8 KB)

Column names in Filter wizard should be case sensitive.

1 Like

Dear @Yoichi

Really sorry for late replay
I just gone through according to your steps below is the screen shot

@Dhanraj_Guduru

Can you try the filter with “age” instead of “Age” as that is how the column is in the excel.

1 Like

Hi @RajeshT

Thanks for your help!
I just downloaded and debug the process still error is reflecting,am not sure whats wrong in my pc

hi @SowmyaLeo

thanks for your help! i just removed age from filter used only income column now it’s working good :slight_smile:

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.