Filter Wizard returning unknown error

UIPath throws me the following error:

RemoteException wrapping System.ArgumentException: the value for argument ‘Column Name’ is not set or is invalid.
at UiPath.DataTableUtilities.DatatableExtensions.GetColumnIndex(DataTable dt,
Object argumentValue,
Boolean throwIfNotFound)
at UiPath.DataTableUtilities.DatatableExtensions.GetColumnIndex(DataTable dt,
InArgument arg,
ActivityContext context,
Boolean throwIfNotFound)
at UiPath.Core.Activities.FilterDataTable.<>c__DisplayClass26_0.b__1(FilterOperationArgument f)
at System.Linq.Enumerable.WhereSelectListIterator2.MoveNext() at System.Collections.Generic.List1…ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
at UiPath.Core.Activities.FilterDataTable.FilterRows(DataTable dataTable,
ActivityContext context)
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)


and

Can anyone help me identify what I’m doing wrong?

Can you show me the column of dtFirstVersion

@rikke

cheers :smiley:

Happy learning :smiley:

1 Like

I mean to keep only certain columns (containing critical information i can’t show - not x1, x2, x3…) The x1, x2, x3 is supposed to represent column headers/names. UIPath reads an excel file and posts it into the dtFirstVersion variable (I think), it does this correctly as there’s no error with the dtFirstVersion

You should double check column names.
E.g. Why some are black and some brown in 2nd screen? Why there is the leading space?

Cheers

worked around it with excel vba as uipath didnt work

1 Like

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