Error , please help

Hi ,

I am getting the following error can anyone please help

RemoteException wrapping System.Data.EvaluateException: Cannot find column [Name].
at System.Data.NameNode.Bind(DataTable table, List1 list) at System.Data.BinaryNode.Bind(DataTable table, List1 list)
at System.Data.DataExpression.Bind(DataTable table)
at System.Data.DataExpression…ctor(DataTable table, String expression, Type type)
at System.Data.DataTable.Select(String filterExpression)
at lambda_method(Closure , ActivityContext )
at Microsoft.VisualBasic.Activities.VisualBasicValue1.Execute(CodeActivityContext context) at System.Activities.CodeActivity1.InternalExecuteInResolutionContext(CodeActivityContext context)
at System.Activities.Runtime.ActivityExecutor.ExecuteInResolutionContext[T](ActivityInstance parentInstance, Activity1 expressionActivity) at System.Activities.InArgument1.TryPopulateValue(LocationEnvironment targetEnvironment, ActivityInstance activityInstance, ActivityExecutor executor)
at System.Activities.RuntimeArgument.TryPopulateValue(LocationEnvironment targetEnvironment, ActivityInstance targetActivityInstance, ActivityExecutor executor, Object argumentValueOverride, Location resultLocation, Boolean skipFastPath)
at System.Activities.ActivityInstance.InternalTryPopulateArgumentValueOrScheduleExpression(RuntimeArgument argument, Int32 nextArgumentIndex, ActivityExecutor executor, IDictionary2 argumentValueOverrides, Location resultLocation, Boolean isDynamicUpdate) at System.Activities.ActivityInstance.ResolveArguments(ActivityExecutor executor, IDictionary2 argumentValueOverrides, Location resultLocation, Int32 startIndex)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

Hi @Varun_Dharni

I think the column name is missing

Can u Share the screenshot of excel file?

@NIVED_NAMBIAR Sure here it is .

No column name is not missing.

@Varun_Dharni
we do see Name. Often in such a scenarion a Space after the column name leads to this issue. May we ask you to check if the column names are text only without any space on start or end. Thanks

Instead of column name try columnIndex

ie instead of row(“Name”).ToString use row(0). ToString

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

@NIVED_NAMBIAR

when I am typing ConfigDT.row(0)(1).ToString compiler is showing an error

Thanks,
Varun.

What error is throwing now @Varun_Dharni

@ppr It worked :slight_smile:

Thanks a ton mate.

@NIVED_NAMBIAR got the solution, kindly see @ppr comments.

Thanks for your help as well.

Regards,
Varun.

1 Like

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