Page 1 of 1

Suggestions for improvement to Import Filter

Posted: Thu 11 Apr 2019 05:49
by hansi9990
It would be nice if it were possible to save the filter settings in connection with the database and the object in profiles.
It would also be good if there is another option "New workbook" in the window "Preview Data" in the Excel Import Options.

Re: Suggestions for improvement to Import Filter

Posted: Mon 15 Apr 2019 16:33
by Pinturiccio
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.
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 also be good if there is another option "New workbook" in the window "Preview Data" in the Excel Import Options.
We will investigate the possibility to create a new workbook when data is imported and post here when we get the results.

Re: Suggestions for improvement to Import Filter

Posted: Tue 16 Apr 2019 18:49
by hansi9990
Cool, thank you. :)
Another Question: Is there a filter possible to remove dublicates? (that only the older entries are stuck when sorting in ascending order for a defined column)

Re: Suggestions for improvement to Import Filter

Posted: Sat 20 Apr 2019 15:38
by Pinturiccio
It is not possible to achieve such results via filters. However, you can use your custom query to select the oldest results for duplicate fields. Let's consider the following example:
1. We have a field date_f, where the date when a record was created is stored.
2. We have a field Name, which can contain duplicates.
3. We will use table name TESTING for this example.
4. If the Name field is duplicate, then select the record with the oldest date_f.

The result query should be the following:

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
You can write your own query in Excel Add-in on the "SQL Query" tab: http://prntscr.com/neju8j