Error when filtering datatable

[MikkoL (Mikko)]

Hi,

I’m receiving the following error without any apparent reason;

"Source: DT XX0200

Message: Data Table

Exception Type: System.ArgumentException"

An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.ArgumentException: Data Table
at UiPath.Core.Activities.FilterDataTable.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

Any ideas what might be the reason for this?

[vilardelld (Daniel Ramos)]

Hello,

You have to define both an “input datatable” and “output datatable”, they could be the same.

Are you providing the information to the activity?

Can you take an screenshot of your propertieS?

Kind regards,
Daniel

[Palaniyappan (Forum Leader)]

@MikkoL

An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.ArgumentException: Data Table

can i have a view onthe filter wizard a screenshot if possible
because we might have missed something in column field
make sure that we have mentioned the columnname between double quotes or with column index alone (just 0 or 1 or 2) as the column index starts from 0 for the first column

Cheers @MikkoL

[MikkoL (Mikko)]

Hi,

Problem solved.

Amateur mistake, I had the original datatable defined 2 times as variable with different scope causing the issue.

Thank you!

[vilardelld (Daniel Ramos)]

Ok, are both of them defined in your workflow?