Remove duplicates from tables and delete them

First remove duplicates by key columns, and then use the kick table to perform set subtraction to obtain a clean result table that can be directly used in office processes.

Remove duplicates from tables and delete them

Process: merge the main tables and deduplicate by column -> read the key value of the kicked table -> remove the hit record from the deduplication result -> output the result and Recurring_Data (including reasons).

History