Hi Team, I am using the below query in an assign operator but it throws error as missing operand after where operator Extractedamount is variable contains 15 TransactionDataTable.Select(“Amount=‘Extractedamount’ where Date in(‘NewDate1’,‘NewDate2’)”).CopyToDataTable not sure what the syntax erro…

@Boopathi the syntax used in select is not 1 to 1 equal to SQL. Have an initial impression on the syntax here: https://www.csharp-examples.net/dataview-rowfilter/ I would suggest to put the filter statement into the select expression. the row selection can be done e.g with a filter datatable acti…

Hi @ppr actually i am getting a result DT like this and using filter datatable activity i am not able to filter both the date values [image] I have a variable Check, amount, code with some values I am checking these values against check amount code values in Result DT for both the dates. If it m…

Try TransactionDataTable.Select(“Amount=‘Extractedamount’ And (Date=‘NewDate1’ OR Date=‘NewDate2’)”).CopyToDataTable

@Boopathi have a look here on how it can be worked with dates within the select expression syntax. have a special look on the surrounding # [image] Filter data table with date and time Studio I’m trying to filter out date time of excel but having hard luck , can someone…

Missing operand after where operator

Help Studio

ppr (Peter Preuss) June 18, 2020, 8:03am 5

@Boopathi
have a look here on how it can be worked with dates within the select expression syntax. have a special look on the surrounding #

Topic		Replies	Views
Filter ExcelData using ExcelData.Select - CopyToDataTable - need help Activities activities , question , system	1	843	November 18, 2021
Linq query(2) Help datatable , excel , uiautomation , studio	15	3839	September 20, 2019
Where can i find dt.select(filterexpression) help document Studio	3	2558	June 10, 2020
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) Studio studio , question , workflow_diff	1	704	July 14, 2023
How to Use Select Method Help	6	31056	December 27, 2018

Missing operand after where operator

Related topics