Syntax error: Missing operand after 'Num' operator. at System.Data.ExpressionParser.Parse() at System.Data.DataExpression..ctor(DataTable table, String expression, Type type) at System.Data.DataTable.Select(String filterExpression)

[Ripusudan_Sharma]

Hello all,
we want to select particular data row from Data table . To achive this we are using following select query -
DT1.Select("Check Num = ‘2426’ AND Invoice Number=‘25-36-37487’ AND Num1=‘5’ ").FirstOrDefault().

Bur we are getting Following error while selecting particular data row from Data table using select query.
Error-Syntax error: Missing operand after ‘Num’ operator. at System.Data.ExpressionParser.Parse()
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)

Kindly Help us with resolving error.I am attching input files which is used in reading Data table
test.xlsx (9.2 KB)

[postwick (Paul)]

@Ripusudan_Sharma

DT1.Select("Check Num = ‘2426’ AND Invoice Number=‘25-36-37487’ AND Num1=‘5’ ").FirstOrDefault().

You have a space in Check Num and Invoice Number so that’s not valid syntax. Put them in [ and ]

DT1.Select("[Check Num] = ‘2426’ AND [Invoice Number]=‘25-36-37487’ AND Num1=‘5’ ").FirstOrDefault()