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