Filter Wizard returning unknown error

[rikke]

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?

[pattyricarte (Patty Boy)]

Can you show me the column of dtFirstVersion

@rikke

cheers

Happy learning

[rikke]

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

[J0ska]

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

[rikke]

worked around it with excel vba as uipath didnt work