Datatable : update without for each activity

[Karthick_Settu]

Yes you can use Datatable.Select(“filter expression”) and please refer this posts.

DataTable.select() versus FilterDataTable activity

I will try to summarize it very simply. Filter Data Table activity works very well with STRING type data. If you use Filter Data Table activity then you cannot play with type conversions. Also if you want to filter using conditions on multiple columns that too of different type, the output will be not the expected one. For example, you want to filter the data from excel/csv with condition like: Age >30 and Gender = “MALE” and Height >5.5 For this situation to achieve this you have to use mul…

DataTable Select with both Variables and Contstants

Hi, I am trying to use a Select in my DataTable. It originally worked with two constants SchedDT.Select(“[Job Level] = ‘11’ AND [Work Location] = ‘London’”) I now need to amend the select to use variables. After scanning the forum I found the syntax to use variables but I am struggling to work out the syntax for one variable and one constant two variables My current attempt is at SchedDT.Select( “[Job Level] = '”+convert.ToString(intLevel)+“'” ) This works fine:grinning: However whe…

Data Table - Select row

I scrape data with data scraping and I need filter or count rows.I know how I can count row when I count year(Str.), ExtractDataTable.Select(“[Poistený Meno/IČO] = '”+ICO+“’ and [Dát.vzniku] like '%”+(CInt(Yearinput)-4).ToString+“'”) this works perfect, but I have problem when I need know how many rows is 01.01.2014 ago.This syntax doesn’t work ExtractDataTable.Select(“[Poistený Meno/IČO] = '”+ICO+“’ and [Dát.vzniku] <'”+DateTime+“'”), DateTime=01.01.2014. Thanks B