Suggestions for improvement to Import Filter
It would also be good if there is another option "New workbook" in the window "Preview Data" in the Excel Import Options.
Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
If the "Allow saving add-in specific data in Excel worksheet" check box is selected in the connection editor window during import, then the select query with filters is stored. In this case, when you click Get Data on an imported worksheet, we show the previously used query with filters.hansi9990 wrote:It would be nice if it were possible to save the filter settings in connection with the database and the object in profiles.
We will investigate the possibility to create a new workbook when data is imported and post here when we get the results.hansi9990 wrote:It would also be good if there is another option "New workbook" in the window "Preview Data" in the Excel Import Options.
Code: Select all
SELECT t.* FROM TESTING t INNER JOIN (SELECT Name, min(date_f) as MinDate from TESTING GROUP BY Name) temp on t.Name=temp.Name and t.date_f=temp.MinDate