I'm trying to find the duplicate rows in a large table. I could create a SQL query that counts when every field has the same value, but there are a lot of columns so that would be a slow job. It seems an ideal task for AI as it is a task with defined parameters for data quality, but Zia could not understand my request.
Even better if it could deduplicate the table for me!