Deduplicate rows in a table or avoid the creation of the same row if exist already.

When querying from external source like QRadar, we frequently get multiple time the same results, of if we do the query again after 24 hours to get new ones, we are duplicating all lines with previous content and current request.
The idea is to create new rows, only if the current one does not exist already, avoiding multiple times the same line, which alter the quality of the table usage by analyst

  • Guest
  • Apr 20 2021
  • Under review