Filter Datatable - Not like filter

[Selvasathappan (Selva)]

Hello Everyone,

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

Thanks
Selva

[arivu96 (Arivazhagan A)]

Hi @Selvasathappan,

use below query

DataTable=DataTable.Select("ColumnName like '%Arivu%'").CopyToDataTable()

More related to datatable information

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName 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)< >''"…

Regards,
Arivu

[Selvasathappan (Selva)]

Thanks dude. You are awesome.

[Selvasathappan (Selva)]

@arivu96, Any thoughts on below issue?

Unable to read CSV - Invalid format

Hello Eevryone, 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 …

[Selvasathappan (Selva)]

@arivu96 - Can you please help me with this?

Citrix Automation - Recognize whether button is enabled/disabled

Hello Everyone, 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…

[Selvasathappan (Selva)]

@arivu96 - Can you please help e with this?

Sort random - Datatable

Hello Everyone, 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?