How to remove duplicate rows from my data My data comes from a MySQL database and it has duplicate rows. I want to keep the original data for historical reasons but I need to apply updates to the latest data rows.
My Problem: I can use a View with a GROUP BY clause in MySQL to remove the duplicates however then I canโt update the data because MySQL doesnโt allow updates on Views with GROUP BY clauses in them. My Question: Is there a way in AppSheet to filter the duplicate rows?
The view Iโm using in MySQL is: SELECT
admin_po._lines GROUP BY po_number , qty , rate , running_total;
In my sample data below the last three lines are a duplicate of the first three. I want to show my App user just the last three lines
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |