+1
Is there a way to filter Datatable based on specific columns using inbuilt Datatable package or other packages? For example, Suppose we have a Datatable with columns “Name and ID”. I want to filter all the data with specific name and ID.
Note - I do not want to use loops since the number of data is high and also cannot write the data to excel and use excel as database query, due to certain limitations in the client environment.
+13
Hi
You can use WHERE in the SELECT query for this requirement. Below is an example. However, depending on the result set, you may still need to loop through the query result for getting each value from it.
SELECT * FROM [Sheet1$$] WHERE (Name) = ‘John’ and (ID) = 1234
+1
Hi
You can use WHERE in the SELECT query for this requirement. Below is an example. However, depending on the result set, you may still need to loop through the query result for getting each value from it.
SELECT * FROM [Sheet1$$] WHERE (Name) = ‘John’ and (ID) = 1234
Thanks for the answer
+13
Hi
You can use WHERE in the SELECT query for this requirement. Below is an example. However, depending on the result set, you may still need to loop through the query result for getting each value from it.
SELECT * FROM [Sheet1$$] WHERE (Name) = ‘John’ and (ID) = 1234
Thanks for the answer
I am sorry. I misread your question. This is for the Database package, and for this, you can use the Database: Read action.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.