Datatable : update without for each activity

[ccma]

Hi,
Is it possible to update value in a Datatable column against certain select criteria, without using 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

[ccma]

Thanks for revert.
But my requirement is not to select.
I have one Datatable, from which I need to update column for few rows say where col2 = “ABC”, without using for each.
Using for each, it will take time for search for required row and then update. So looking for an alternate.

[Ragu9060 (Raguvarthan)]

@ccma

Find the attached code, here i have added flow to fit your requirement.

Solution.zip (8.5 KB)