A proposed “vendors” entity type points at a random spreadsheet imp…

Question

A proposed “vendors” entity type points at a random spreadsheet import table full of duplicate vendor names. What source choice is better?

Accepted Answer

Point the entity type at a governed vendor or company source table with cleaner unique records. — Feeding vendor entities from a messy import sheet is like building a phone book from coffee-stained napkins—you get three “Acme”s and no owner. Aim the entity type at a governed vendor or company table. Clean source data beats heroic dedupe later.

Answer

Keep the duplicate import table because entity generation deduplicates any source automatically.

Answer

Use the incident table as the vendor master for GRC entities.

Answer

Create vendor entities only as attachments on Knowledge articles.

A proposed “vendors” entity type points at a random spreadsheet import table full of duplicate vendor names. What source choice is better?

Short Explanation

Full Explanation