Connect to Database, Execute Query: only take certain rows from data table

Learning Hub
1

Hello,

I currently am getting a datatable from a database with the execute query activity.
The only problem is that I get a datatable that has around 50,000 lines which does take a long time to load.

Is there a way to use execute query to give me only the lines containing the information I need?

Ex: Have a lines that contain the data 2020/02/22 and the datatable will only give me those lines in the date column.

2

@dvn -

1- modify your sql query with adding additional where clause to fetch the results with contain data 2020/02/22

2 - you can choose one of the below listed data table filter options to filter existing datatable data …

1 Like