Can anyone please help me with the syntax for “Like” operator in filtering a datatable
Couldn’t find in this forum as well. Moreover when I try it returns as a datarow but I want to have a datatable. Even if I try to declare the assign “To” variable as “DataTable”, I am getting an error message that Datarow cannot be converted to DataTable
use below query
DataTable=DataTable.Select("ColumnName like '%Arivu%'").CopyToDataTable()
More related to datatable information
Use below code to remove empty row from the table.
Use assign activity
DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable()
Re-usable Component pass Parameter as datatable you will get the answer.
RemoveEmptyRows.xaml (8.5 KB)
Remove rows based on particular column is empty.
DataTableName.Select("Convert(column3, System.String)< >''"…
Thanks dude. You are awesome.
@arivu96, Any thoughts on below issue?
I am not able to read a csv file using “Read CSV” operator. It throws an error message as “Invalid format”
However I was able to open other CSV files earlier. The only difference between the CSV file which threw error and the other one is the date format.
File read successful - had date format in DD.MM.YYYY
File read failure - had date format in DD/MM/YYYY.
How can I read CSV with the date format as is. Even if I have to make manipulation to the data, I have to read to make …
@arivu96 - Can you please help me with this?
I am trying to Find a record in a citrix application. However sometimes due to application issue(old application), it doesn’t return the result even if the element is present. But one good thing is if a record is found, it returns the result immediately and “Stop” button is disabled and the loading bar is also empty. On the other hand when the record is not found, the “Stop” button is enabled and loading bar shows progress in green color. Is there any way, I can use any activity…
@arivu96 - Can you please help e with this?
Is there a way to sort the datatable in a random order? I mean I would like to shuffle the rows of my datatable. Can anyone please help me? I don’t want it follow any order like ascending/descending. I want to induce randomness to the data order. Please note am using version 2017.1.6682. There is no filter datatable activity as such. I usually use select clause for that but how do we do it when we want the data to be in random order?